Interested to Buy Any Domain ? << Click Here >> for more details...
CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING?
IF SO HOW?
- 6 Answers
- 20090 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 |
What is data transformation manager process?
Q. Informatica workflow, it is running beyond two hours for last couple of runs, normally it completed less then 30 min., hardly 40 min, last couple of run crossing 2 hours and more in that workflow only one session. now it is aasign to you that how to idenitfy the performance issue of the sesion of production.
What are roles and groups and benefits of using them?
Can we run session without using workflows?
Write the prerequisite tasks to achieve the session partition?
What is difference between stored procedure transformation and external procedure transformation?
daily how much amount of data send to production?
I have a flat file, want to reverse the contents of the flat file
What is a test load?
differences between service based and product based?
How to extract sap data using informatica?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Teradata 
