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

what type of transformation is not supported by mapplets?

4 Answers   CTS,

i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?

6 Answers   Thomson Reuters,

How you know when to use a static cache and dynamic cache in lookup transformation?

0 Answers  

can v update d records in target using update stargey without generationg primary key ? explain

4 Answers   CTS,

my source is junk data how will u remove that junk data by using unix please any one replay me

0 Answers   Cap Gemini,




What is polling?

1 Answers  

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

0 Answers   CTS,

What is the filename which you need to configure in UNIX while installing infromatica?

2 Answers   Accenture,

Is it possible to create multiple domains on a single Informatica server?

0 Answers  

How can i set break points in debugging mode ? can explain steps please?

1 Answers   ABC, TCS,

1)can anyone explain how to use Normalizer transformation for the following scenario Source table | Target Table | Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh Ramesh 68 82 78 | ENG 68 73 81 Himesh 73 87 89 | MAT 82 87 79 Mahesh 81 79 64 | ART 78 89 64 | please explain what should be the normalizer column(s) The GCID column 2)Also please explain the Ni-or-1 rule.

5 Answers   FCS, IBM, Satyam, TCS,

What are the types of metadata that stores in repository?

2 Answers  

For more Informatica Interview Questions Click Here
Categories