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

How can u insert o ne row in the target if that row does not
exists in the target and update if it exists

Question Posted / guest

Answers were Sorted based on User's Feedback



How can u insert o ne row in the target if that row does not exists in the target and update if it ..

Answer / sudhar

Use the session properties,
In Target Properties use options
Insert
update else Insert
Check boxes.

Is This Answer Correct ?    15 Yes 1 No

How can u insert o ne row in the target if that row does not exists in the target and update if it ..

Answer / sujana

by using scd type2 v can do dis

Is This Answer Correct ?    9 Yes 3 No

How can u insert o ne row in the target if that row does not exists in the target and update if it ..

Answer / abhinav

By using an UPDATE STARTEGY transformation.

DD_UPDATE = If the record alreadye exists

DD_INSERT = If the record is a new one

Is This Answer Correct ?    4 Yes 2 No

How can u insert o ne row in the target if that row does not exists in the target and update if it ..

Answer / suresh

scd type 2

Is This Answer Correct ?    1 Yes 0 No

How can u insert o ne row in the target if that row does not exists in the target and update if it ..

Answer / sailu

Do look up on the target with the key values. Check if the
look up is null or not. If look up value is null insert it
and if look up value is not null update it using update
strategy transformation with DD_UPDATE

Is This Answer Correct ?    1 Yes 0 No

How can u insert o ne row in the target if that row does not exists in the target and update if it ..

Answer / chandrasekar

Hi Sudhar,

Please check your answer it is not working....

We can use the SCD type 1 only get the new row as insert
into target and updated record as update into target.

If it wrong means please mail me.. chandranmca2007@gmail.co

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

What is Performance tuning in Informatica?

1 Answers   CTS, GE, TCS,

What are the technical challenges faced in Informatica production support member? Give any one example and how to solve it?

0 Answers   CTS, Wipro,

when we dont use aggregator in mapping ?

2 Answers   CSC,

What is the meaning of decode in informatica?

0 Answers  

In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?

4 Answers  




in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?

9 Answers   Target,

Tell me about Propagate functions in informatica

0 Answers  

Can we have a Mapping without a Source Qualifier?

14 Answers   Deloitte,

connected and unconnected lookups?

4 Answers  

Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

6 Answers   IBM,

SO many times i saw "$PM parser error " .what is meant by PM?

1 Answers  

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

0 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories