How will you update the row without using update statergy?
Answer Posted / ganesh
1) If the target table doesn't have primary key, then using
update override we can update the records.
2) If target table have primary key, then we have option
called update else insert in session properties. Based upon
that we will update the records.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is a dimensional model?
what are factless facts? And in which scenario will you use such kinds of fact tables.
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What is a grid in Informatica?
What is the use of target designer?
what is index?how it can work in informatica
Why do you use Mapping Parameter and mapping variable?
Tell me about Propagate functions in informatica
What are the new features of informatica 9.x developer?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is domain in terms of informatica?
What is rank transformation in informatica
write a query to retrieve the latest records from the table sorted by version(scd)
What are the advantages of using informatica as an etl tool over teradata?
What is the function of union transformation?