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

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / kalpana

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 do you migrate data from one environment to another?

0 Answers  

Hi, Steps for upgrading from informatica 7x to 9x or the link which will help me to upgrade from informatica 7 to 9. Regards, Eva

1 Answers   Accenture,

Plz can anybody send Informatica and Cognos FAQ Plz To thid ID anil643@gmail.com (or) kumar643@gmail.com

0 Answers  

what are challenges that you faced in testing? give solution to it?

1 Answers  

Which one is better performance wise connected/un-connected lkp?why?

2 Answers   HCL, TCS,

what is mean by throghput? in informatica

3 Answers   Cap Gemini,

What is a taget load order?

2 Answers   IBM,

HOW TO YOU LOAD TIME DIMENSION

1 Answers  

What are the reusable transformations?

0 Answers   Informatica,

what is incremental loading ?

12 Answers   CTS, IBM, Oracle, TCS,

How to run a session, which contains mapplet?

1 Answers  

can u apply SCD2 on flat file tgt? if yes wat is the procedure?

3 Answers   Deloitte,

For more Informatica Interview Questions Click Here
Categories