Informatica Data Warehousing Question:
Download Questions PDF

What is a time dimension? give an example?

Answer:

In 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.

Download Informatica Data Warehousing Interview Questions And Answers PDF

Previous QuestionNext Question
How can we transform row to column?Explain Why dimenstion tables are denormalized in nature?