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 Posted / 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 |
Post New Answer View All Answers
What is union transformation in informatica?
Design a mapping to load the cumulative sum of salaries of employees into target table?
Enlist the tasks for which source qualifier transformation is used.
What are ETL Tools?
What is meant by active and passive transformation?
What are the reusable transformations?
What is the benefit of partitioning a session?
What is meant by incremental aggregation?
What is decode in static cache?
How might you approve all mappings in the archive all the while?
What is a joiner transformation?
How to join three sources using joiner?
Explain the features of connected and unconnected lookup.
EXL informatica Questions
What are pre and post-session shell commands?