Interested to Buy Any Domain ? << Click Here >> for more details...
HOW TO GET THE LATEST DATA IN SCD ?
- 4 Answers
- 21754 Views
- TCS, I also Faced
- E-Mail Answers
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 |
What is the functionality of update strategy?
Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?
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?
Define maping and sessions?
how will you get 21 to 30 record from 50 records?
What are the new features of informatica 9.x in developer level?
Why is meant by direct and indirect loading options in sessions?
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
have you developed documents in your project? and what documents we develop in realtime?
What is power center repository?
How i can upload the MainFrame source For Informatica ?
List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys
Teradata 
