Can we update a target table (without primarykey) by using update strategy tra

Can we update a target table (without primarykey) by using
update strategy transformation?

Question Posted / maheedhar

4 Answers
22705 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Can we update a target table (without primarykey) by using update strategy transformation?..

Answer / ratalarayudu

hi ,

Yes we can update a target table without having a primary
key. we have a property TARGET UPDATE OVERIDE .By overring
we can update .

Regards,
Rayudu.

Is This Answer Correct ?

27 Yes

0 No

Can we update a target table (without primarykey) by using update strategy transformation?..

Answer / zak

1. We can define a primary key at the informatica level and configure session properties for Treat rows as "Update as Update" and check the Update check box.
2. If we shud not define the primary key at informatica level, then we can use Update override in Target properties. But i m not very sure of this. Kindly let me know

Is This Answer Correct ?

6 Yes

2 No

Can we update a target table (without primarykey) by using update strategy transformation?..

Answer / mithilesh kumar rai

With Same logic with Update Strategy tr,
just Select Primary Key Option in Target Table Definition.

It will work without defining the Target table.

Regards
Mithilesh Kumar Rai

Is This Answer Correct ?

0 Yes

6 No

Can we update a target table (without primarykey) by using update strategy transformation?..

Answer / maheedhar

I said No,Kindly correct me if am wrong.......

Is This Answer Correct ?

1 Yes

8 No

Post New Answer