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 difference between olap and datawarehosue?
What are the advantages of raid 1, 1/0, and
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
What is application.cfm?
Explain how to get the first 100 rows from the flat file into the target?
How to allow a dynamic selection of a column for a measure in a chart,without using variable?
Explain Association algorithm in Data mining?
Suggest a good author for hyperion in data warehousing?
What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?
Is union transormation is active transformation?
What is a relationship?
What is the difference between star and snowflake schemas?
Explain normalization?
What is the difference between datawarehouse and bi?
I need to set predefined condition. How I do this?