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
How you prepared reports for OLAP?
Performance tuning( what you did in performance tuning)
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Write the unconnected lookup syntax?
What is a mapplet/worklet in informatica?
Explain the features of connected and unconnected lookup.
Explain sessions and how many types of sessions are there?
What is resilience time?
Explain your project of banking domian.
What is the use of target designer?
What is an Integration service in Informatica?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What is native users?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
what is the Default Source Option For Update Strategy Transformation?