Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / harshad
Adding few points
You can use stagin area for your transformation befor it
load it in DW. Also It could be de normalised way then
linked with Dimension to load Fact.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the advantages data mining over traditional approaches?
In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?
What is the differences between star and snowflake schemas?
What is the main difference between schema in rdbms and schemas in datawarehouse?
How many project sources we can create in metadata?
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
Who needs data warehousing?
Explain what are the various reporting tools in the market?
Why null values are mapped as 0 in fact tables?
Explain the difference between data ware house & data mart?
What is is the guidelines to build universe with better performance? R performance tuning issues of universes?
Explain swot analysis?
how much memory space occupied real time project (roughly)?
Why denormalization is promoted in universe designing?
What is static and local variable?
