Interested to Buy Any Domain ? << Click Here >> for more details...
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
Explain Dataware house architecture .how data flow from intial to end?
What is meant by pre and post session shell command?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What do mean by local and global repository?
What are session parameters ? How do you set them?
What is incremental aggregation?
How will the document be delivered to me?
Write the advantages of partitioning a session?
What is a grid in Informatica?
What is the use of source qualifier?
What is depict expression change?
Implementation methodology
What is a filter transformation and why it is an active one?
How to update source definition?
How can we improve session performance in aggregator transformation?
