CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING?
IF SO HOW?
Answer Posted / gunnala
Yes, we can implement slowly changing dimensions concept with Type1 and Type2, provided we need to have same source and knowledge of how to use mapplet designer
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All 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
What are the popular informatica products?
Define mapping and session?
is it possible to index the data in cache of lkp transformation ?
Briefly explain the aggregator transformation?
Under which circumstances, informatica server creates reject files?
my source is junk data how will u remove that junk data by using unix please any one replay me
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
How to partition the Session?
What do mean by local and global repository?
Explain in detail scd type 2 through mapping.
What does role playing dimension mean?
What is joiner transformation in informatica?