If we set dd_insert in mapping and Delete in session properties what will happen

If we set dd_insert in mapping and Delete in session properties what will happen.?

Question Posted / karan_kapoor603

4 Answers
8375 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

If we set dd_insert in mapping and Delete in session properties what will happen.?..

Answer / sweta kedia

Yes it will perform delete as session properties overrides
mapping properties.

Is This Answer Correct ?

10 Yes

1 No

If we set dd_insert in mapping and Delete in session properties what will happen.?..

Answer / roshan

It will perform delete.

Is This Answer Correct ?

7 Yes

1 No

If we set dd_insert in mapping and Delete in session properties what will happen.?..

Answer / insha

It will perform delete operation since session defines run
time properties of mapping

Is This Answer Correct ?

3 Yes

1 No

If we set dd_insert in mapping and Delete in session properties what will happen.?..

Answer / usha

It will perform delete.
because session properties overide mapping properties.

Is This Answer Correct ?

3 Yes

1 No

Post New Answer

More Informatica Interview Questions

hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.

10 Answers

Under which circumstances, informatica server creates reject files?

0 Answers Informatica,

What is polling?

1 Answers

1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.

0 Answers

how to calculate the optimum cache size in aggregator transformation?

1 Answers

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

0 Answers CTS,

Write the program through which the records can be updated?

0 Answers

How union transformation is active ?

2 Answers Puma,

why we are using surogate key in real time give me explanation

2 Answers TCS,

What is galaxy shema

2 Answers CGI,

How can you join two tables without any common column present in them?

1 Answers TCS,

If we have lookup table in workflow how do you trouble shhot to increase performance?

2 Answers

For more Informatica Interview Questions Click Here