Interested to Buy Any Domain ? << Click Here >> for more details...
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
How would you copy the content of one repository to another repository?
Enlist the differences between database and data warehouse.
How to generate sequence numbers?
What is target load order?
State the differences between sql override and lookup override?
What is workflow monitor?
How to update source definition?
How big was your fact table
Explain about Informatica server process that how it works relates to mapping variables?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What do think which one is the better joiner or look up?
What is the need for an etl tool?
Enlist the various types of transformations.
Can informatica load heterogeneous targets from heterogeneous sources?
can we override a native sql query within informatica? Where do we do it?
