Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


Can we insert and update a target table without using update
strategy transformation?How?

Answers were Sorted based on User's Feedback



Can we insert and update a target table without using update strategy transformation?How?..

Answer / rayudu

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
T/r.

Regards,
rayudu.

Is This Answer Correct ?    10 Yes 2 No

Can we insert and update a target table without using update strategy transformation?How?..

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 ?    6 Yes 0 No

Can we insert and update a target table without using update strategy transformation?How?..

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 ?    5 Yes 0 No

Can we insert and update a target table without using update strategy transformation?How?..

Answer / guest

yes,using target override property

Is This Answer Correct ?    0 Yes 5 No

Post New Answer

More Informatica Interview Questions

What is a connected transformation?

0 Answers   Informatica,


how to load dimension table and fact table. plz tell me the steps.

0 Answers   Cognizant, IBM,


My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.

5 Answers   Amdocs,


How to Join Tables my Source is having 15 table target is one?

4 Answers   TCS,


Which is the best place to learn Informatica Powercenter Online Training?

1 Answers  


How can we improve session performance in aggregator transformation?

0 Answers   Informatica,


Scheduling properties,whats the default (sequential)

0 Answers  


what is the size of your data warehousing?

0 Answers   IBM,


what is dimension table?

17 Answers  


how to create user defined function (udf) in informatica

0 Answers   Informatica,


MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION

4 Answers  


Does Facttable Normalized or Denormalized?

2 Answers   IBM,


Categories