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.
Clarify the aggregator change?
How can you validate all mappings in the repository simultaneously?
What is a connected transformation?
Parameter and variable differences
What do think which one is the better joiner or look up?
Informatica Checkpoints
What are the main issues while working with flat files as source and as targets ?
can anyone suggest best free Talend data integration training online
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
what is index?how it can work in informatica
Can we get 1st record through Informatica(without sequence number).
How can we store previous session logs?
Define joiner transformation?
