can v update d records in target using update stargey
without generationg primary key ? explain
Answer Posted / leo gilbert
By using "Update override" option in the target. Say the
key of your table is ID,NAME. But your mapping is passing
only ID to the target then you can have an update override
query in the target to update the target only based on
ID.
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is workflow manager?
What is the maplet?
Which are the different editions of informatica powercenter that are available?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
what is Active lock explain
How might you approve all mappings in the archive all the while?
Explain the tuning lookup transformation - informatica
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
How can you validate all mappings in the repository simultaneously?
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 kind of issue you will get in environment? (we ll call help desk to raise ticket rite?