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 is deployment group?
Explain the informatica workflow?
How do you load only null records into target?
Make a note of the quantity vaults made in informatica?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
How do you take back up of repository?
what is song in infrmatica...?
What is an active transformation?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is persistent lookup cache?
What all join we can perform in LOOKUP transformation?
What is informatica powercenter repository?
difference between informatica 8.1.1 and 8.6
What are the transformations that are not supported in mapplet?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??