Interested to Buy Any Domain ? << Click Here >> for more details...
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...
- 1 Answers
- 3897 Views
- I also Faced
- E-Mail Answers
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 are the components of Informatica? And what is the purpose of each?
Explain what are the different types of transformation available in informatica.
How to differentiate between the active and passive transformations?
What is sorter transformation?
what are 3 tech challenges/ common issues you face?
What is different between the data warehouse and data mart?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Enterprise data warehouse your projects phase by phase explain?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What is transformation?
When do you use sql override in a lookup transformation?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What is informatica worklet?
Explain scd type 3 through mapping.
