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

Dovelopment work (mapings,workflows)and unit testing also done in informatica ,then wt we do ? pls give me detail?

1 Answers

Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation

1 Answers TCS,

suppose we have 1 to 10 records.In router transformation we had given two condition A>= 5 A<=5 then what will be the output?

2 Answers emc2,

in what type of scenario bulk loading and normal loading we use?

2 Answers Cognizant, Wipro,

Is it possible to define a single node as a Gateway node as well as worker node?

0 Answers

write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000

5 Answers CTS,

There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping

3 Answers Wipro,

how to load rows into fact table in data warehouse

0 Answers Informatica,

What is dynamic cache?

0 Answers

IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?

2 Answers

hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks... Send me----: raghukrams@yahoo.com

0 Answers

Can you use one mapping to populate two tables in different schemas

2 Answers

For more Informatica Interview Questions Click Here