Does Facttable Normalized or Denormalized?
Answers were Sorted based on User's Feedback
Fact tables are normalized. Dimension tables are denormalized
Is This Answer Correct ? | 27 Yes | 0 No |
How to extract original records at one target & Duplicate records at one target?
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 ??
How do you migrate data from one environment to another?
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 update or delete the rows in a target, which do not have key fields?
What if the source is a flat-file?
Explain the difference between a data warehouse and a data mart?
Explain what are the different types of transformation available in informatica.
What is the format of informatica objects in a repository?
How to Create a folder using pmrep command?
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?
Describe expression transformation?