Answer Posted / bidhar
In SCD 2 you must be generating the surrogate keys.
Example:
Customername Address Customer_id Customer_identifier
Amit Bangalore 100 10
Amit Hyderabad 100 11
Amit Pune 100 12
Amit Mumbai 100 13
Here column Customer_identifier is the surrogate key.
so for latest record ,you can pick up the record which have
maximum surrogate key value(13).
Let me know if i am wrong.
Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What is meant by lookup transformation?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Can we create two repositories on same database instance in oracle?
What are the steps involved in the migration from older version to newer version of Informatica Server?
How can we use mapping variables in informatica? Where do we use them?
Which transformation should we use to normalise the COBOL and relational sources?
What is informatica? Why do we need it?
What are the measure objects?
What is a snowflake schema?
How to do unit testing in informatica?
What is informatica etl tool?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Explain dynamic target flat file name generation in informatica
What are the different transaction levels available in transaction control transformation?