How to update data in a non primary key table

Question

I have one table - TableA. This is source and target also. Table doesn't have any primary key. I am fetching data from TableA, then doing some calculation on some fields and updating them in same tableA. Now how can I update data when it doesn't have any primary key or composite key? Second question - If joining two columns make a record unique then how can I use it in informatica?

Plz help

Answer 1

You can define the update statement in the target. There is that properties. Still you have to make informatica to perform an update, not insert. To do that you need to use the update strategy. I think you don't need in this solution to make any PK on that table, because you will use your own update statement, but please verify this.

To set the fields and make proper where condition for update you need to use :TU alias in the code. TU -> means the update strategy before the target.

Example:

update t_table set field1 = :TU.f1 where key_field = :TU.f5

Answer 2

To update the record you have to define the record uniquely.
Either you can create primary key at the database level or you can define it at Informatica level. After that you can update the record through Update Strategy Transformation or you can use session level properties to do the same.