4.Explain Snowflkeschema ?
- 6 Answers
- 9500 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
Explain what are the advantages and disadvantages of reporting directly against the database?
Explain what are the various methods of getting incremental records or delta records from the source systems?
Explain what are the various transformation available?
Explain can a dimension table contains numeric values?
How can you set the client management?
What is the use of incremental aggregation? Explain me in brief with an example?
How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?
What are diagrams?
Explain what is the difference between datawarehouse and bi?
If two relational tables are connected to sq trans, what are the possible errors it will be thrown?
The same tier?
What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?
Describe the differences between a data warehouse and data mart.
Explain what is difference between query studio and report studio?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
