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?
- 6 Answers
- 11606 Views
- I also Faced
- E-Mail Answers
Answer Posted / prasad
use scd3 concept or use scd2 concept
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is the difference between stop and abort in informatica
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Enlist few areas or real-time situations where informatica is required.
Briefly define reusable transformation?
What is a transaction control 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
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
Differentiate between source qualifier and filter transformation?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What is the way to execute pl/sql script using informatica mapping?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
How you can differentiate between connected lookup and unconnected lookup?
Define sessions in informatica etl?
What is blocking transformation?
