Answer Posted / 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 |
Post New Answer View All Answers
When do you use sql override in a lookup transformation?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Explain about Informatica server process that how it works relates to mapping variables?
Different circumstance which drives informatica server to expel records?
Define mapplet?
How to delete duplicate row using informatica?
How do you migrate data from one environment to another?
Explain the use of aggregator cache file?
Explain how many types of dimensions are available in informatica?
How do you update the records with or without using update strategy?
Explain in detail scd type 2 through mapping.
What is a difference between complete, stop and abort?
What is domain in terms of informatica?
How many input parameters can exist in an unconnected lookup?
What could be the possible resons of locks by user?