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
Explain the data types present in bo n wht happens if we implement view in the designer n report?
Explain bus schema?
What is meant by metadata in context of a data warehouse and how it is important?
What is recovering sessions?
Why fact table is in a normal form?
Explain what is the difference between view filter and report filter?
How much data hold in one universe.
Explain what is the limit to the number of sources and targets you can have in a mapping?
What is meta data and system catalog?
What is the difference between olap and oltp?
What are the various file formats involved in reportnet?
How to add a number to a macro variable?
What is difference between query studio and report studio?
What is the difference between star and snowflake schemas?
How to reduce warnings?