can v update d records in target using update stargey
without generationg primary key ? explain
- 4 Answers
- 16123 Views
- CTS, I also Faced
- E-Mail Answers
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
Make a note of the quantity vaults made in informatica?
When do you use sql override in a lookup transformation?
What are the designer tools for creating transformations?
How to do the error handling of if ur source is flatfiles?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What do you mean by worklet?
What is the meaning of decode in informatica?
What are the performance considerations when working with aggregator transformation?
what is the size of u r source(like file or table)?
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 data transformation manager process?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
How to extract sap data using informatica?
How does the aggregator transformation handle null values?
What are the types of lookup transformation?
