Skip navigation
Contact Us
857 Views 3 Replies Latest reply: Nov 5, 2012 6:50 AM by Miguel Elías Manchado RSS
Miguel Elías Manchado Newbie 4 posts since
Sep 11, 2012
Currently Being Moderated

Nov 3, 2012 3:07 AM

Problems with Transaction Control

Hi All


I  am loading one table and i want to commit each row in oracle database because I'm fetching that row for the reference of next row.

I have use  Transaction_control transformation but it don't works.

The validating tell me that this transformation is ineffective.


I use the TC transformatión just after a expresión that increment in 1 a value (I can't use sequences)

The mapping line is like that:

Source --> SQ --> Exp --------------------------------------------------------> JNR

Source --> SQ --> Exp Transformation --> TC Transformation --> JNR --> Exp --> 4 x UPD (3 insert + 1 update) --> 4 x Targets


One of this targets take the valor of sequence and when I use the TC just before the UPD update, the mappin is invalid



What can I do?



More Like This

  • Retrieving data ...

Bookmarked By (0)