CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING?
IF SO HOW?
Answer Posted / chandrasekar
We have to take same source for both scd type1 and type 2.
First , we can take the router Transformation and create two
groups one is scd type1 and scd type2. With that source we
can implement the both type1 and type 2. If anybody want the
workflows means please mail me.
My mail id is chandranmca2007@gmail.com
Thanks.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is an Integration service in Informatica?
What are the reusable transformations?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What could be the possible resons of locks by user?
How to elaborate powercenter integration service?
What is option by which we can run all the sessions in a batch simultaneously?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Enlist the tasks for which source qualifier transformation is used.
how tokens will generate?
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
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Enlist the differences between database and data warehouse.
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What is an active transformation?
What are the prerequisite tasks to achieve the session partition?