Sign Up Login


  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

there is a mapping with expression and mapping we create
some condition for insert and update and followed by update
startegy ,can we update and insert on a single target based
on condition?

Question Posted / mehul.thakur


there is a mapping with expression and mapping we create some condition for insert and update and f..

Answer / gm

Yes, We can do both in Update Startegy,
SOURCE-SQ-EX-LKP-UPD-TAGET

In Update Startegy IIF(ISNULL(EMPID),DD_INSERT,DD_UPDATE)

Is This Answer Correct ?    8 Yes 0 No

Post New Answer

More Informatica Interview Questions

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

0 Answers  

Can we call a stored procedure from a unix script which is run using command task

1 Answers   TCS,

If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?

2 Answers  

I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

0 Answers  

with out using update strategy transnsformation how to update the data in mapping level

1 Answers  

how can u generate sequence of values in which target has more than 2billion of records.(but with sequence generator u can generate upto 2 biliion only)

6 Answers   Accenture,

How can we get multiple output values using an unconnected lookup transformation?

2 Answers   TCS,

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

0 Answers   Puma,

What is joiner cache?

2 Answers   TCS,

How do you manage the Parameter files while migrating your data from one environment to another environment?

0 Answers  

What is critical mapping?

2 Answers  

what is the method of error handling when session is running?

1 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories