Can we insert and update a target table without using update
strategy transformation?How?
- 4 Answers
- 21726 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
How to call shell scripts from informatica?
What are the databases that informatica can connect to windows?
permutations of mapplet
What is olap (on-line analytical processing?
Write the unconnected lookup syntax and how to return more than one column.
Where do we use mapping variables in informatica?
What are the main features of Oracle 8i with context to datawarehouse?
Explain the use of aggregator cache file?
How to create the source and target database connections in server manager?
What is a rank transform?
What are the settings that you use to configure the joiner transformation?
How do you load alternate records into different tables through mapping flow?
if we have a delimiters at unwanted places in a flat file how can we over come those.
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Mention few power centre client applications with their basic purpose?
