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
Different qualification between a related rotate toward the sky and isolates look upward?
How to load last n records of file into target table - informatica
4 yrs etl devloper roles and responsibilities?any body give solutions
How can you differentiate between powercenter and power map?
How can one identify whether mapping is correct or not without connecting session?
Briefly describe lookup transformation?
What is an aggregator transformation?
Enterprise data warehouse your projects phase by phase explain?
What is domain in terms of informatica?
Why is sorter an active transformation?
Write the unconnected lookup syntax?
What can we do to improve the performance of informatica aggregator transformation?
Enlist the advantages of informatica.
Explain what is informatica metadata and where is it stored?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?