Skip navigation
Contact Us
507 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?

 

Thanks.

More Like This

  • Retrieving data ...

Bookmarked By (0)