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

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

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

0 Answers   HP,


IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????

3 Answers   IBM,


how to duplicates from expression transformation without using sorter before that

1 Answers  


Flat file heaving 1 lack records and I want to push 52000 records to the target?

7 Answers  


I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?

2 Answers  






what are the limitation of sorter transformation?

2 Answers   TCS,


Why update strategy and union transformations are active?

0 Answers  


how to use incremental load?

2 Answers   TCS,


which quality process u can approach in ur project

1 Answers   CTS,


From where we can start or use pmcmd?

3 Answers  


Why do you use Mapping Parameter and mapping variable?

0 Answers  


why we need informatica

2 Answers   HCL,


Categories