Does Facttable Normalized or Denormalized?

Answers were Sorted based on User's Feedback



Does Facttable Normalized or Denormalized?..

Answer / chandrasekar

Fact tables are normalized. Dimension tables are denormalized

Is This Answer Correct ?    27 Yes 0 No

Does Facttable Normalized or Denormalized?..

Answer / hari prasad

fact tables contains normalized.

Is This Answer Correct ?    11 Yes 0 No

Post New Answer

More Informatica Interview Questions

How to extract original records at one target & Duplicate records at one target?

12 Answers  


Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??

3 Answers   IBM,


How do you migrate data from one environment to another?

0 Answers  


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

0 Answers  


How to update or delete the rows in a target, which do not have key fields?

0 Answers   Informatica,






What if the source is a flat-file?

0 Answers  


Explain the difference between a data warehouse and a data mart?

0 Answers  


Explain what are the different types of transformation available in informatica.

0 Answers  


What is the format of informatica objects in a repository?

0 Answers  


How to Create a folder using pmrep command?

0 Answers  


S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?

5 Answers   TCS,


Describe expression transformation?

0 Answers  


Categories