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 SDLC way of code development?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
Explain pmcmd command usage in informatica
Briefly describe lookup transformation?
Enlist the advantages of informatica.
explain one complex mapping with logic? sales project?
what is index?how it can work in informatica
What is the benefit of partitioning a session?
Where are the source flat files kept before running the session?
Which are the different editions of informatica powercenter that are available?
What is a surrogate key?
What are the performance considerations when working with aggregator transformation?
how we can load rejected record's at run time?(not through bad files)
How to improve the performance of a session using sorter transformation?
Suppose we do not group by on any ports of the aggregator what will be the output?
