CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING?
IF SO HOW?
- 6 Answers
- 18514 Views
- I also Faced
- E-Mail Answers
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 |
If we are using an aggregator but forget to mention the group by port .what will be the output??
What are the new features of informatica 9.x developer?
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID anil643@gmail.com (or) kumar643@gmail.com
Using Connected or unconnected lookup for performance wise which one is preferable?.
What is lookup transformation?
What is informatica? What exactly are the practical uses in real world
What are the settings that you use to configure the joiner transformation?
What is confirmed dimension and fact?
What are the main issues while working with flat files as source and as targets ?
what is mean by flag 4 in update strategy t/r
following scenario empsal table i want who exist one lakshs sal above monthwise? ` empsal empid monthyear sal 1 jan2008 1000 2 march2009 50000 3 april2009 4000 4 feb2009 100000 5 jul2009 600000 6 dec 2008 90000
how tokens will generate?
Teradata 
