Interested to Buy Any Domain ? << Click Here >> for more details...
4.Explain Snowflkeschema ?
- 6 Answers
- 11632 Views
- EDS, HCL, IBM, iFlex, TCS, I also Faced
- E-Mail Answers
Answer Posted / sathish arichandran
Each Dimension table has been split into more than one
dimension and connected with centralized fact table. It has
bigger size than star schema. Dimensions are sliced
deeply with the business requirements.
But it is tough to understandable since it has more tables
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can we run the graph? How can we schedule the graph in unix?
Explain what is a three tier data warehouse?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?
What are universe requirements?
What is incremintal loading?
What are the steps of implementing data warehousing?
What are the differences between datamart vs. Reporting cube?
What are the advantages and disadvantages of reporting directly against the database?
What are loops in Datawarehousing?
How can we acheive correlated sub-query in designer?can anyone help me in this regard?
Explain reference cursor?
What is an error log table in informatica occurs and how to maintain it in mapping?
What is the use of tabular model, tabular sql, tabular reference in real time application?
What is the difference between ods and oltp?
What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?
