HOW TO GET THE LATEST DATA IN SCD ?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / raj
IN THREE WAYS WE CAN GET THE LATEST RECORD IN SCD ...
1)IN "SCD TYPE 2 TIME STAMP" FOR LATEST RECORD THE "END
DATE" FIELD WILL BE BLANK. THAT MEANS IT IS THE NEW ROW .
2)IN "SCD TYPE 2 FLAG " THE FLAG NUMBER OF THE NEW ROW WILL
BE ONE .
3) IN " SCD TYPE 2 VERSION " THE LATEST RECORD IS HAVING
THE MAXIMUM VERSION NUMBER .
Is This Answer Correct ? | 13 Yes | 2 No |
Answer / vikneswaran
in type 1 ... only the latest date... so it is very easy to get
in type 2.. to get by using date or flag or version
in type 3.. to get by selecting previous_column
Is This Answer Correct ? | 4 Yes | 0 No |
Which transformation should we use to normalise the COBOL and relational sources?
If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?
how do the project develops? pls specify right from the start to end in step by steps.
what is the logic will you implement to load data into a fact table from n dimension tables?
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@yahoo.co.in
In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?
Which is the t/r that builts only single cache memory?
How to load data in informatica ?
how to join the two flatfiles using the joiner t/r if there is no matching port?
how to create a sample mapping for dynamic lookup transformation
How to differentiate between the active and passive transformations?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?