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

hi all, can anyone please tell me the difference between erwin tool and informatica ?how these both works ? how this both are going to connect with business objects. THANKS IN ADVANCE

2 Answers  


I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?

11 Answers  


what is data driven in informatica

5 Answers   IBM,


write a query to retrieve the latest records from the table sorted by version(scd)

0 Answers   Informatica,


can we override a native sql query within informatica? Where do we do it?

0 Answers  






How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?

2 Answers   iFlex, TCS,


checkout and checkin in informatica 8.6

3 Answers   TCS,


Can we change Dynamic to Static or Persistent cache? If so what happens?

0 Answers   TCS,


How to join three sources using joiner?

0 Answers  


What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

0 Answers   IBM,


PLS REAL TIMERS IAM WAITING FOR FAVOROBLE REPLY..REGARDING ETL TESTING INFORMATION...ETL TESTER NEEDS ETL DEVOLPMENT KNOWLEDGE OR NOT..?. IF HE NEED DEVLPMNT KNOW WHAT HE LEANR FIRST... AS A DEVOLOPER U KNOW THE ETL TESTING PROCESS.. PLS EXPLAIN IN DETAIL THANK U

2 Answers  


I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

0 Answers  


Categories