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
What is meant by lookup transformation? Explain the types of lookup transformation?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What are the features of complex mapping?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What does “tail –f” command do and what is its use as an Informatica admin.
What is meant by LDAP users?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What will be the approach?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Differences between version 7.x and 8.x.
How does a rank transform differ from aggregator transform functions max and min?
How can you increase the performance in joiner transformation?
What is pmcmd command?
What is aggregate cache in aggregator transformation?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?