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

if the session fails after 100 records agian we have to starts the session or we go for recovery session

2 Answers   TCS,

what is Partitioning ? where we can use Partition?

2 Answers   IBM, TCS,

What are the types of presistent cache in look up tr.

0 Answers   IBM,

what is constraint based loading

2 Answers   IBM,

WAT IS TEXT LOAD?

3 Answers   Wipro,




What are teh different tasks that can be created in workflow manager?

1 Answers   NIIT,

What is the surrogate key?

0 Answers  

What is workflow? What are the components of the workflow manager?

0 Answers  

Under which circumstances, informatica server creates reject files?

0 Answers   Informatica,

Hi I have a source (flat file) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd "[19012005124259]_Anfrage-Vendors.doc [19012005124336]_Anfrage.xls" 103 def "[19012006092602]_IMG_0310.JPG 19012006092631]_IMG_0311.JPG [19012006092702]_IMG_0312.JPG [19012006092727]_IMG_0313.JPG" But I need to generate duplicate records based on attachments column. Target (Table) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd 19012005124259]_Anfrage-Vendors.doc 102 bcd [19012005124336]_Anfrage.xls 103 def [19012006092602]_IMG_0310.JPG 103 def [19012006092631]_IMG_0311.JPG 103 def [19012006092702]_IMG_0312.JPG 103 def [19012006092727]_IMG_0313.JPG 103 def [19012006092750]_IMG_0314.JPG 103 def [19012006092814]_IMG_0315.JPG Here no. of Attachments we can't decide because it is dynamic. It will be great if somebody help me on this. Thanks in Advance. ganga

2 Answers  

What are the types of caches in lookup? Explain them.

0 Answers  

Is there any model difference between ODS and DWH

2 Answers   Zensar,

For more Informatica Interview Questions Click Here
Categories