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
What is lookup change?
What is expression transformation?
What if the source is a flat-file?
What is the difference between STOP and ABORT options in Workflow Monitor?
How to handle decimal places while importing a flatfile into informatica?
design of staging area?
What do you mean by enterprise data warehousing?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
whats the logic to load the lower level of granularity of data to fact table.
How do you migrate data from one environment to another?
What is exclusive and normal mode for repository services?
Enlist the differences between database and data warehouse.
What are the differences between oltp and olap?
What are the settings that you use to configure the joiner transformation?
tell me about your project functionality
