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...


what r d pre-requiste for update strategy transformation,
and differnce between delete n truncate in target session
properties for update strategy

Answers were Sorted based on User's Feedback



what r d pre-requiste for update strategy transformation, and differnce between delete n truncate i..

Answer / vikas

Update Strategy Works on Tables and not on files. In session, Treat source rows should be data driven.

Is This Answer Correct ?    1 Yes 0 No

what r d pre-requiste for update strategy transformation, and differnce between delete n truncate i..

Answer / abhinaw prakash

For update strategy t/r we should have Constraints defined
on the table.
Else we'll have to use Update override property in session
properties.
Delete in session property we use for deleting a record
based on condition were as truncate is for removing the
previous record from the table before inserting new set of
data.

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More Informatica Interview Questions

How to Create a folder using pmrep command?

0 Answers  


i have 2 mapings for this 2 mapings i want use only one lookupt/r how?

3 Answers   Wipro,


Hi, What is version control in Informatia ? Can anyone just give an idea or introduction about this? Advance Thanks

2 Answers   IBM,


i have ten flat files with same structure,if i want to load it to single target,and mapping needs to should show only one source.what will be the steps to taken to achieve it?/

5 Answers   L&T,


i want excute multiple sessions in one workflow using the "start task".what do i need to do?

2 Answers  


What is A complex mapping?

3 Answers   TCS,


After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?

3 Answers   TCS,


What are the associated ports in look up T/R.

5 Answers   IBM, Zensar,


What does role playing dimension mean?

0 Answers  


Write the different tools in the workflow manager?

0 Answers  


how will you get 21 to 30 record from 50 records?

6 Answers  


What is meta data and system catalog?

2 Answers  


Categories