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
- 23155 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 olap (on-line analytical processing?
Explain what are the different types of transformation available in informatica.
what is Active lock explain
Can we change Dynamic to Static or Persistent cache? If so what happens?
Name the different lookup cache(s)?
What are the types of schemas we have in data warehouse.
What is the meaning of up gradation of repository?
What is powercenter on grid?
What is informatica? Why do we need it?
Explain the pipeline partition with real time example?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What is intricate mapping?
How do you remove duplicate records in informatica? And how many ways are there to do it?
what are 3 tech challenges/ common issues you face?
Differences between version 7.x and 8.x.
