Hi All,
I need to join more than 5 tables from different databases on same key. My current job design is - using three join stages to join all these tables in same job.
Is it suggestible to have one join stage in design to join all tables at once or joining two tables with join stage and remaining two tables with other join stage by keeping the same partition?
If I use three join stages to join all these tables, I think I wont overload scratch space (As it is parallel, it will free up the scratch space as data is moving to next stage). In this design, off course it will create more processes but I feel it give more performance.
Please share your ideas/suggestions on this design.
Thanks..
Multiple Join stages with Same Join Key
Moderators: chulett, rschirm, roy
Multiple Join stages with Same Join Key
--
Swathi Ch
Swathi Ch
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Hard to tell. More stages may result in more processes, which may help throughput (assuming operator combination to be disabled and a server that's not overloaded).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: