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
- 23318 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 are mapplets?
Can informatica load heterogeneous targets from heterogeneous sources?
explan ur project architecture?
What are the main features of Oracle 8i with context to datawarehouse?
How do you handle two sessions in Informatica
Explain constraint based loading in informatica
What does update strategy mean, and what are the different option of it?
Describe the impact of several join conditions and join order in a joiner transformation?
What are roles and groups and benefits of using them?
What is meant by LDAP users?
How can repository reports be accessed without sql or other transformations?
How will the document be delivered to me?
how tokens will generate?
How many dimensions are there in informatica?
Explain the features of connected and unconnected lookup.
