CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING?
IF SO HOW?
Answers were Sorted based on User's Feedback
Answer / basava
yes we can do scd type1 and scd type2 in a single mapping
itself when the source is same for both. But with same
source we will never face that situation if so the changes
in source will reflect both scd1 and scd2.
Is This Answer Correct ? | 7 Yes | 3 No |
Answer / ankit kansal
yes we can achieve both scd1 and scd2 with in the same mapping in informatica just router to define the flow and use update strategies as per the required logic...
http://deepinopensource.blogspot.in/
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / chiranjeevi.madam
we can implement scd1 and scd2 in different pipelines with same source in a single mapping.
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / 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 |
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 |
how can we load first and last record from a flat file source to target?
7 Answers Infosys, ITC Infotech,
Reusable transformation and shortcut differences
What is the difference between normal and bulk loading? Which one is recommended?
major difference between normal loading and bulk loading?
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
Can you start a batches with in a batch?
what is materialized view?
How can you display only hidden files in UNIX
wht is cdc?how to use it in creation of mappings?
what is curr val use for in sequence generator?
What is Test load plan? Let us assume 10 records in source, how many rows will be loaded into target?
MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION