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
- 23558 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
Explain the difference between a data warehouse and a data mart?
How to create or import flat file definition in to the warehouse designer?
How can we remove the duplicates from flat file source?
How do you update the records with or without using update strategy?
What is domain in terms of informatica?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What could be the possible resons of locks by user?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
How would you copy the content of one repository to another repository?
Where is metadata stored?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Explain sessions. Explain how batches are used to combine executions?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
