Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

what is the function of 'F10' informatica ?

4 Answers   IBM,

What is aggregate awareness?

1 Answers  

What are the mapping parameters and mapping variables?

0 Answers   Informatica,

What is domain and gateway node?

0 Answers  

where to select code page option?

2 Answers   TCS,

what is the significance of newlookup port in dynamic look up

1 Answers   IBM,

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  

Can we run session without using workflows?

5 Answers   TCS,

Explain how many types of dimensions are available in informatica?

0 Answers  

What is deployment group?

0 Answers  

If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?

1 Answers   TCS,

can anyone suggest best free Talend data integration training online

0 Answers  

For more Informatica Interview Questions Click Here
Categories