Hi ETL 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..please let me know in case of any concerns...
Answer / hemanth
yes, u can see the out put in single run,
in mappings tab one option is there, that is TARGET LOAD
ORDER.
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 ? | 1 Yes | 0 No |
comonly how meny mappings r there in Banking projects?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
what is target update override and when we use it?
How to load a Dimension ? and how to load a fact table?
Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??
How do you join more than 3 flat files in informatica?
"Change cache" in Informatica ?
what is shortcut in informatica? difference between shortcut,reusable object?
Without using any transformations how u can load the data into target?
how to get flatfile containg 10 records half records one target another half another target
What is lookup change?
If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?