What is a time dimension? give an example?
Submitted by: AdministratorIn a relational data model, for normalization purposes, year lookup, quarter lookup, month lookup, and week lookups are not merged as a single table. In a dimensional data modeling(star schema), these tables would be merged as a single table called TIME DIMENSION for performance and slicing data.
This dimensions helps to find the sales done on date, weekly, monthly and yearly basis. We can have a trend analysis by comparing this year sales with the previous year or this week sales with the previous week.
Submitted by: Administrator
This dimensions helps to find the sales done on date, weekly, monthly and yearly basis. We can have a trend analysis by comparing this year sales with the previous year or this week sales with the previous week.
Submitted by: Administrator
Read Online Informatica Data Warehousing Job Interview Questions And Answers
Top Informatica Data Warehousing Questions
☺ | Explain What is batch and describe about types of batches? |
☺ | Explain How to import oracle sequence into Informatica? |
☺ | Explain How many types of dimensions are available in Informatica? |
☺ | What is the difference between informatics 7x and 8x and what is latest version? |
☺ | How to do unit testing in informatica? |
Top Data Warehouse Job Categories
☺ | Warehouse Assistant Interview Questions. |
☺ | Ab Initio Interview Questions. |
☺ | Data Stage Interview Questions. |
☺ | ColdFusion Interview Questions. |
☺ | Data Warehouse Supervisor Interview Questions. |