Sign Up Login


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

one source to target loading insert new rows and update
existing rows?

Question Posted / dinesh

Answers were Sorted based on User's Feedback



one source to target loading insert new rows and update existing rows?..

Answer / s

We can achieve this

SRC->EXP->UPD->TGT.

In Update Transformation put DD_UPDATE. And in target add
update_override to update the required columns based on the
condition. At session level set the target load attribute
as INSERT, UPDATE ELSE INSERT.

Is This Answer Correct ?    5 Yes 0 No

one source to target loading insert new rows and update existing rows?..

Answer / jay

SQ ---------> UPD --> TRG
| ^
| |
--> LKP --

In update startegy, just give type as formula
iif(isnull(LKP_Col1), 0, 1)

0 --> DD_INSERT
1 -->DD_INSERT

Is This Answer Correct ?    4 Yes 1 No

one source to target loading insert new rows and update existing rows?..

Answer / ppl

using scd type 2 v can do dis

Is This Answer Correct ?    3 Yes 1 No

Post New Answer

More Informatica Interview Questions

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

1 Answers   TCS,

Describe expression transformation?

0 Answers  

What is a mapplet/worklet in informatica?

0 Answers  

i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source

1 Answers  

How to load duplicate records in to a target table which has a primary key?

2 Answers  

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

0 Answers   IBM,

what are presession,postsession success and postsession failure commands ?

1 Answers  

My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.

3 Answers   Cognizant,

What is sequence generator transformation in informatica?

0 Answers  

What is the difference between Bitmap and Btree index?

3 Answers   Mind Tree,

Is it possible to revert a global repository to local one and why?

0 Answers  

How to load the data from people soft hrm to people soft erm using informatica?

0 Answers  

For more Informatica Interview Questions Click Here
Categories