Interested to Buy Any Domain ? << Click Here >> for more details...
Can we update a target table (without primarykey) by using
update strategy transformation?
- 4 Answers
- 23649 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / zak
1. We can define a primary key at the informatica level and configure session properties for Treat rows as "Update as Update" and check the Update check box.
2. If we shud not define the primary key at informatica level, then we can use Update override in Target properties. But i m not very sure of this. Kindly let me know
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
How would you join a node to the already existing domain?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is the difference between writing a joiner query in ANSI style and THETA style?
What is event and what are the tasks related to it?
What is parallel processing in informatica?
What is informatica etl tool?
What are roles and groups and benefits of using them?
How many numbers of sessions can one group in batches?
What are the different transaction levels available in transaction control transformation?
What is a code page?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What is the way to execute pl/sql script using informatica mapping?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Mention few advantages of router transformation over filter transformation.
