how we can update a target table without update strategy and
update override?
Answers were Sorted based on User's Feedback
Answer / moorthy g
In Session Properties
Treat source row as: update
This way you can update in the target
Best Regards
Moorthy. G
| Is This Answer Correct ? | 7 Yes | 2 No |
Answer / bhupal
In session properties we can use update as update to update the target but target should contain the primary key in base table or in informatica level.
| Is This Answer Correct ? | 1 Yes | 0 No |
What are the popular informatica products?
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
How do you remove duplicate records in informatica?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
what are the settiings that u use to cofigure the joiner transformation?
What are the performance considerations when working with aggregator transformation?
what is data driven?
Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar
need for registering a repository server
What are the types of maping in Getting Started Wizard?
how the informatica server sorts the strings values in rank transformations?
following table source name gender a1 male a2 female how to change 'male' to 'female' and 'female' to 'male'