Can we update a target table (without primarykey) by using
update strategy transformation?
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 to load the data from people soft hrm to people soft erm using informatica?
How you can differentiate between connected lookup and unconnected lookup?
How you prepared reports for OLAP?
Partition, what happens if the specified key range is shorter and longer
tell me 5 session failure in real time how can you solve that in your project?
How to open an older version of an object in the workspace?
Explain the tuning lookup transformation - informatica
How many ways a relational source definition can be updated and what are they?
What do you mean by blocking transformation?
How can you increase the performance in joiner transformation?
Performance tuning( what you did in performance tuning)
Explian the Process of deployment groups in informatica
What is a standalone command task?
What is the need for an etl tool?
What is the reusable transformation?