why dimenstion tables are denormalized in nature ?

Answer Posted / siddu

For fast retrieval(to Perform a SELECT Operation)

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the tuning techniques you applied during your last project

1661


SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

1777


Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1674


What does role playing dimension mean?

715


In how many ways we can create ports?

799






Explain the mapping variable usage example in informatica

725


What are the different lookup cache(s)?

712


On which transformations you created partitions in your project?

870


While importing the relational source definition from the database, what are the metadata of source that will be imported?

909


How to go to the older version for a mapping?

688


What is meant by active and passive transformation?

679


To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

753


i have a data in my source as a flat files what test i have to perform the next step can any body help to me

1788


How is union transformation utilized?

676


What is the benefit of partitioning a session?

740