Hi gurus can any one tell me with a flow how to implement SCD
Type 1 and SCD Type 2 in a single mapping.For some fields SCD
type has to be implemented and for some fields scd type has to
be implementd..Thank in advance....
Answer Posted / kiran ghatage
You will find this in following examples...
https://community.informatica.com/solutions/mapping_implementing_scd1_using_md5
https://community.informatica.com/solutions/mapping_scd_type_2_effective_date
https://community.informatica.com/solutions/mapping_scd_type_2_versioning
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a transaction control transformation?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
can we override a native sql query within informatica? Where do we do it? How do we do it?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Differences between connected and unconnected lookup?
Explain scd type 3 through mapping.
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What is rank transformation?
What is a filter transformation and why it is an active one?
While migrating the data from one environment to another environment how would you manage the connections?
How many ways are there to create ports?
Slowly changing dimensions, types and where will you use them
How identifying bottlenecks in various components of informatica and resolving them?
What do mean by local and global repository?