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
- 23677 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
what is the size ur source like(file system or database)? how many record daily come u r banking project?
How does the aggregator transformation handle null values?
What is rank transformation?
What is informatica worklet?
How do you convert single row from source into three rows into target?
What is a sequence generator transformation?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What are some examples of informatica etl programs?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What are the features of complex mapping?
How many input parameters can exist in an unconnected lookup?
What are the different options available for update strategy?
Which transformation should we use to normalise the COBOL and relational sources?
What are data-driven sessions?
Explain lookup transformation source types in informatica
