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 degenerate dimension table?
What are the different types of datawarehosuing?
What are session timeout and application timeout? Where we have to do this process?
why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.
what are the other factors of the database on which the loading performance depend?
Explain how many ways you create ports?
Explain what type of indexing mechanism do we need to use for a typical datawarehouse?
What is the metadata extension?
Explain what are the basic needs to join two sources in a source qualifier?
What is a hash cluster?
Explain what is ods (operation data source)?
What are necessary tasks to install reportnet software?
What are the differences between star and snowflake schema?
what is an use case?
Explain what are the advantages and disadvantages of reporting directly against the database?