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
Why is sorter an active transformation?
What is the difference between informatics 7x and 8x and what is latest version?
How will the document be delivered to me?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What are the advantages of informatica?
How many number of sessions can one group in batches?
What are the types of schemas we have in data warehouse and what are the difference between them?
Explain target update override in informatica
How can you differentiate between powercenter and power map?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is data caches/ index caches?
What do think which one is the better joiner or look up?
What is Data Caches size?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Mention few power centre client applications with their basic purpose?