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

what is polling?

1 Answers   Informatica,


Mapplets ( can you use source qyalifier, can you use sequence generator, can you use target)

1 Answers  


HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.

8 Answers   CTS,


how can we load first and last record from a flat file source to target?

7 Answers   Infosys, ITC Infotech,


How to display First letter of Names in Caps?

7 Answers  


8.what is mapplet ?give example?

2 Answers  


I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?

5 Answers   Span Systems,


What are the new features of informatica 7.1?

2 Answers  


Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.

7 Answers   Cognizant, Wipro,


What are the new features of informatica 9.x at the developer level?

0 Answers  


How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

0 Answers   Informatica,


what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?

3 Answers  


Categories