4.Explain Snowflkeschema ?
- 6 Answers
- 9477 Views
- EDS, HCL, IBM, iFlex, TCS, I also Faced
- E-Mail Answers
Answer Posted / samir kumar sahoo
In snowflake schema the dimension table(denormalized table)
will be further divided into one or more dimentions
(normalized tables) to organize the infomation in a better
structural format.To design snowflake we should first
design star schema design.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the difference between view materialized view and view?
What are the different types of segments?
if you use oracle sql*loader , how do you transform data with it during loading?
Explain er diagram?
Can any one explain the hierarchies level data warehousing.
What are the types of SCD?
how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause
How do you define data block size?
What is the main difference between star and snowflake star schema? Which one is better and why?
What is vdl (view definition language) explain?
How to export mappings to the production environment?
Compare cold fusion with other programming languages?
What are the advantages of query studio compared to report studio?
How to get the first 100 rows from the flat file into the target?
How to join 3 database like flat file, oracle, db2 in informatrica?
