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

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

Question Posted / dinesh

3 Answers
7192 Views
Polaris, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

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

task is running successfully but data is not loded why?

2 Answers

What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort

3 Answers

Hello...... How can i set my mapping as read-only? Please answer me. Advance thanks

4 Answers

source table have single column single record having with single space. load that source record into trg . trgt having two columns and the SOURCE TABLE LIKE COL1 BHANU PRASAD TRGT TABLE COL1 COL2 IN THAT LOAD THE RECORD IN THE trgt table LIKE COL1 COL2 BHANU PRASAD HOW ? TELL ME PLZ

2 Answers Wipro,

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

0 Answers

What is Test load plan? Let us assume 10 records in source, how many rows will be loaded into target?

3 Answers Logica CMG,

when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/

5 Answers L&T,

Design a mapping to get year of join for each employee.

4 Answers Accenture,

How to delete the data in the target table after loaded.

3 Answers TCS,

how remove 1st 3 records & last 3 records in informatics

4 Answers TetraSoft,

i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.

3 Answers

What are the joiner caches?

3 Answers Informatica,

For more Informatica Interview Questions Click Here