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 are the various file formats involved in reportnet?
What are the different types of datawarehosuing?
Explain the importance of data warehouse?
Is there any rownum object from which we can do this?
How did you plan your Data ware house project?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
What is vldb(very large databases)?
What are the data types present in bo?
What is conformed fact?
explain about dirty dimension?
Explain dimension table ?
Explain how to get the first 100 rows from the flat file into the target?
Explain what is the advantages data mining over traditional approaches?
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?
What are the main steps to build the data warehouse?