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 can u tune u r informatica mapppings

2 Answers   CTS,


difference between top down(w.h inmon)and bottom up(ralph kimball)approach?

2 Answers   PayPal,


If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks

7 Answers   Puma,


What is data transformation manager process?

0 Answers  


How do you change a non-reusable transformation to reusable transformation?

0 Answers  






HOW TO GET THE LATEST DATA IN SCD ?

4 Answers   TCS,


Hi experts, can anyone tell how much we use plsql in real time

3 Answers  


There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session??

9 Answers   TCS,


In how many ways we can create ports?

0 Answers  


I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?

8 Answers   DELL,


wtite sql query following table are city gender no chennai male 40 chennai female 35 bangalore male 10 bangalore female 25 mumbai female 15 i want the output? city male female chennai 40 35 bangalore 10 25 mumbai null 15

3 Answers   Bank Of America,


How can we handle two sessions in informatica?

0 Answers  


Categories