Interested to Buy Any Domain ? << Click Here >> for more details...
Can we insert and update a target table without using update
strategy transformation?How?
- 4 Answers
- 23372 Views
- Syntel, I also Faced
- E-Mail Answers
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
What is complex mapping?
Explain incremental aggregation in informatica
Briefly define a session task?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
list out all the transformations which use cache?
What is the surrogate key?
What is exclusive and normal mode for repository services?
What is workflow monitor?
What differs when we choose the sorted input for aggregator transformation?
What is Cognos script editor?
What is the meaning of decode in informatica?
In informatics server which files are created during the session rums?
What is repository manager?
scenario where i can use only concurrent execution of workflow.
