Why should we use star schema in datawarehouse design?
Answer Posted / jz
1) Query performance is high.
2) It consume less space compare to SnowFlake.
| Is This Answer Correct ? | 4 Yes | 6 No |
Post New Answer View All Answers
What are the types of presistent cache in look up tr.
What is joiner change?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
lookup transformation with screenshots
what is the -ve test case in your project.
Partition, what happens if the specified key range is shorter and longer
What is substr in informatica?
What are the static cache and dynamic cache in informatica?
What are the different options available for update strategy?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
How to extract sap data using informatica?
What is a sequence generator transformation?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab