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
Need of an active stage between two passive stages
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 247
- Joined: Thu Apr 27, 2006 6:38 am
- Location: Hyderabad
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.
Teradata Certified Master V2R5
No, you do not need to put in a dummy stage.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 247
- Joined: Thu Apr 27, 2006 6:38 am
- Location: Hyderabad