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
What is mapping debugger?
What is a repository? And how to add it in an informatica client?
How do you convert single row from source into three rows into target?
Name the different lookup cache(s)?
what are 3 tech challenges/ common issues you face?
What are the types of presistent cache in look up tr.
What is main use of mapplet?
How do you load unique records into one target table and duplicate records into a different target table?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What is domain in terms of informatica?
How to generate or load values in to the target table based on a column value using informatica etl tool.
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
Define update strategy?
can anyone explain me about retail domain project in informatica?
Is it possible to revert a global repository to local one and why?
