CODEWITHSUNDEEP
etlinformaticainformatica-powercenteriics
Pavan bm
Pavan bm

Reputation: 1

Informatica new column data loading into existing target table

I have an requirement as there is one existing target table and now requirement is we have included one new column to it and the data to the target table should load from a new source table in new mapping, so how can I proceed with this requirement,kindly help

I tried taking target as lookup and some process but it's not working out, kindly give me ur valuable suggestions

Upvotes: 0

Views: 743

Answers (1)

Koushik Roy
Koushik Roy

Reputation: 7407

If your source extracts full data everyday, you dont have to do anything. But if its incremental, then you need to create a special mapping to update all/one newly created column( basically update historical data). You can follow below steps -

  1. Use the target as source and target both. Choose PK and the newly added column and link to next.
  2. Then add an expression transformation. Re-create the logic for the newly added column. If you need to join or do a lookup to source or any other table, you can do it in this place.
  3. Link newly added column and primary key to the target.
  4. Mark the session as update only or you can use update strategy.

Whole mapping will look like below -

TGT_SQ --> EXP...Other Trnfs... --> TGT

If both source and target are in same DB, you can use direct update as well.

Upvotes: 0

Related Questions