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
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Explain how to import oracle sequence into informatica?
What is the sql query overwrite in source qualifier in informatica
what are factless facts? And in which scenario will you use such kinds of fact tables.
What are session parameters ? How do you set them?
What is a predefined event?
What is decode in static cache?
where to store informatica rejected data? How to extract the informatica rejected data?
How to load the data from people soft hrm to people soft erm using informatica?
What are Dimensional table?
What are the types of caches in lookup?
Explain the difference between mapping parameter and mapping variable?
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.
Explain target update override in informatica
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
