Transaction Control

[ProDev]

Guys,


Source : 1(one) Flat file (.txt)
Target : 2(two) Oracle tables (each having 2 insatances inside the mapping.)

Here is what, I want to handle in my mapping

2 insatnces (T1 & T2) of the 1st target table need to be commited first, irrespective of the Instances T3,T4 (of 2nd target table).

I find that, all such transaction controls are happening as a single COMMIT /ROLLBACK. But, I want to make this independent of each other in my targets.
Was trying the same using Transaction Control transformation available in Informatica V 6.2. But could not achieve anything great.


Any helpful guidelines of such situation ??


Thanks

 

[smajay]

Hi,

This can be done using 2 flows in the same mappings.
suppose x is flat file and ta and tb are the 2 targets.
assume ta1 and ta2 are the 2 instances of ta target
and tb1 and tb2 are the 2 instances of tb target.
so create 2 workflows in mapping as follows:

1 st flow
|----ta1
1. x-source file--><include transformations here>--
|____ta2

2nd flow
|----tb1
2. x-source file--><include transformations here>--
|____tb2

Than click on the Mapping tab on tool bar->target load plan>click this set the target load plan for ta1 and ta2 first and than tb1 and tb2.for this you will see 2 sql qualifier each source qualifier have one taget, so u need to arrange this according to your need i.e. 1st sq qualifier should be first and than second. so when you run the session data first will be loaded into ta1 and ta2 and than tb1 and tb2.

Please let me know if you have any doubt and also feedback if it worked fine or not. i did this way no. of times so no chance of not working. but good say if worked.

-Ajay Chidrawar