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 informatica? Why do we need it?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What is sq transformation?
what is INFORMATICA TESTING process
Explain how many types of dimensions are available in informatica?
How can you validate all mappings in the repository simultaneously?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Explain what transformation and how many are there in informatica?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What do you mean by filter transformation?
Please let me know how to make Data masking in informatica..
What is expression transformation?
what is diff b/t sorter t/r and agg have the option sorter property...
Did u used latest transformations of 8.6.0? for what?
How might you approve all mappings in the archive all the while?