Can we insert and update a target table without using update
Answers were Sorted based on User's Feedback
Yes By default if we wont use update stratagey t/r it will
insert the record by default .And if we want to update
without using update stratagey give the property UPDATE for
TreatSource rows at session level and in target properties
give updateas Update so that we can update without using UPD
|Is This Answer Correct ?||9 Yes||2 No|
Answer / sreedhar lokaray
Yes you can insert or update a table without using update
strategy. In the Mapping tab of the Session property go to
Target properties and check the attribute value Insert to
insert or check Update as Update to update.
|Is This Answer Correct ?||5 Yes||0 No|
Answer / 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 ?||1 Yes||0 No|
Answer / guest
yes,using target override property
|Is This Answer Correct ?||0 Yes||4 No|
what is constraint based loading
State the differences between sql override and lookup override?
How do you do error handling in Informatica?
What if the source is a flat-file? Then how can we remove the duplicates from flat file source?
Hi, This is Lakshmi,Anyone taking classes for datawarehouse-Informatica and BO with real time project
If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.
What is Target Update Override? What is the Use ?
Explain the scenario which compels informatica server to reject files?
in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?
Can any one give me an example for factless fact table ? If your answer is studunt attendence registration,could you plese give me explanation for this ?
What is meant by query override?
Define the various join types of joiner transformation?