On a day, I load 10 rows in my target and on next day if I
get 10 more rows to be added to my target out of which 5 are
updated rows how can I send them to target? How can I insert
and update the record?
Answer Posted / rohan
Here the requirement is to update the existing record and insert the new record. Its nothing but SCD1
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
COM components can be used in Informatica
lookup transformation with screenshots
Explain in detail scd type 2 through mapping.
What are roles and groups and benefits of using them?
What are the types of lookup transformation?
Quickly characterize reusable change?
What is the maplet?
what is the -ve test case in your project.
Explain dynamic target flat file name generation in informatica
How many dimensions are there in informatica?
What is an active transformation?
What is an Integration service in Informatica?
What are the performance considerations when working with aggregator transformation?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
What is a grid in Informatica?