Answer Posted / kittu
It is clearly apt for snowflake schema because in snow flake schema dimension table are further splits the de-normalized table into small normalized dimensions to decrease the table space and also to increase the performance this can be done with help on foreign key and primary key constraints
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is the size of your data warehousing?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What do think which one is the better joiner or look up?
Enterprise data warehouse your projects phase by phase explain?
What is a code page?
What does command task mean?
How can you increase the performance in joiner transformation?
What are the types of data warehouses?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
How can we remove the duplicates from flat file source?
What is rank transformation?
What is a router transformation?
How big was your fact table
What are the static cache and dynamic cache in informatica?
What is the difference between source qualifier transformations source filter to filter transformation?