Informatica Target Table update 1

[sa0309]

Using Informatica PC 9.0.1

I'm fairly new to PC.

I have a target table that has 5 columns. I want to update column3 to '0' for every row, every time the session runs ( no conditional updates ).

update TableA
set column3 = '0'

I've looked into sql transformation and update strategy transformations. Still not clear on how to do this.

Any suggestions would be appreciated.

Thx!

 

[rasETL]

Since you want to update every row in the Table a Transformation will not work unless you process source transactions for every row.

I think your best bet would be to add the Update DML to the "Post SQL" for the Target Mapping in the Session.

Open the Session - Mapping Tab - Target - Scroll down to Post SQL - add ...

update TableA set column3 = '0'

 

[sa0309]

That worked perfectly. Thank you!!