Can we insert and update a target table without using update
strategy transformation?How?
Answer Posted / kajal mishra
Yes we can update records in informatica without update strategy .
During session configuration, you can select a single database operation for all rows using the Treat Source Rows as setting from the ‘Properties’ tab of the session.
Insert :- Treat all rows as inserts.
Delete :- Treat all rows as deletes.
Update :- Treat all rows as updates.
Data Driven :- Integration Service follows instructions coded into Update Strategy flag rows for insert, delete, update, or reject..
In case we set treat rows as update , we can set more option for individual target tables.
I found a good asrticle on http://tutorialcorner.com/2016/03/update-without-update-strategy-in-informatica/
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
How would you join a node to the already existing domain?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Design a mapping to load a target table with the following values from the above source?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Do you find any difficulty while working with flat files as source and target?
Write the prerequisite tasks to achieve the session partition?
What is a difference between complete, stop and abort?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Explain the tuning lookup transformation - informatica
Explain sql transformation in script mode examples in informatica
How many ways are there to do 'remove duplicate records in informatica'?
Can you generate sequence numbers without using the sequence generator transformation?
difference between informatica 8.1.1 and 8.6
What is a surrogate key?
What are the different types of repositories created using informatica?