Interested to Buy Any Domain ? << Click Here >> for more details...
HOW TO GET THE LATEST DATA IN SCD ?
- 4 Answers
- 21577 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 |
In a simple mapping when i use aggregate t/r with out any condition or group by, i am getting output as only last record in the table . can any one explain it please.........?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
How to elaborate tracing level?
what is the process we used in joiner transformation,there is no matching column in sources?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?
Briefly explain the aggregator transformation?
Q. WE ARE LOADING ORACLE TABLE THE PROCESS RUNS THREE HOURS. THIS TABLE IS BEING USED BY SOME DOWNSTREAM TEAMS SO WHAT WE WANT IS IN BETWEEN RUN IS PROGRESS IF ANYONE IS FETCHING THE DATA FROM THE TABLE THEY SHOULD SEE DATA TILL YESTERDAY TILL THAT. AFTER THAT PROCESS IS COMPLETED ONLY THEN TEAM SHULD BE AVAIBLE TO SEE TODAY DATA UPDATED. WE DONOT WANT TO LOG THE TABLE. NEED APROACH FROM YOUR SIDE.
How we can create indexes after completing the load process?
Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,
sir presently i am persuing my m.tech recently i got job in tcs as fresher presently iam doing my 9 months project related to informatica can any one guide me how to create fact tables what type of schemas must be used and so on if so give ur mail ids so that i can contct through it
What are the designer tools for creating tranformations?
Teradata 
