Need of an active stage between two passive stages

devidotcom · Post by **devidotcom** » Thu Apr 24, 2008 2:51 am

Hi All,

I am loading data from a dataset to a Oracle table using a ODBC stage. I remember I read that its always advisable to use a active stage between two passive stages. Like a copy stage in this example of mine.

Can you advice on this.

Thanks
Devi

hamzaqk · Post by **hamzaqk** » Thu Apr 24, 2008 4:17 am

Yes you do need to put a non processing state( passive stage) between two processing stages( active stage). in the server job you could avoid this by allowing inter process communication but for parallel jobs i dont think we can do that hence we need to explicity insert a passive stage to avoid errors.

ArndW · Post by **ArndW** » Thu Apr 24, 2008 4:45 am

No, you do not need to put in a dummy stage.

devidotcom · Post by **devidotcom** » Thu Apr 24, 2008 9:00 pm

Ok.. thanks so a load from a dataset to an Oracle table can be done directly.
Thanks