Interested to Buy Any Domain ? << Click Here >> for more details...
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....
- 1 Answers
- 3589 Views
- I also Faced
- E-Mail Answers
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
Please let me know how to make encryption and decryption with example?
Why update strategy and union transformations are active?
Explain constraint based loading in informatica
How big was your fact table
What is meant by lookup transformation? Explain the types of lookup transformation?
what is the size of u r source(like file or table)?
Can you generate sequence numbers without using the sequence generator transformation?
tell me about your project functionality
How to generate sequence numbers?
How to join three sources using joiner? Explain though mapping flow.
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Do you find any difficulty while working with flat files as source and target?
Under what condition selecting sorted input in aggregator may fail the session?
What are the advantages of using informatica as an etl tool over teradata?
Explain the different dimensions.
