joining tables
Moderators: chulett, rschirm, roy
joining tables
I have 5 tables that are joined on a common key. On some of the tables, there is a one-to-many relationship. What is the best way to do this in DataStage? In our last version, i believe we had a "Join" stage we could use, although i never used it. We don't have it installed yet for version 7. Would that be the best way to go about joining our multiple tables together? Or is there another, better way to do this?
Eric
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If they're all in the same database, join them with SQL; you may require outer joins depending on the exact relationships.
If they're from disjoint databases, you can use the ODBC stage's multi-row return from lookup capability.
If they're from disjoint databases, you can use the ODBC stage's multi-row return from lookup capability.
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: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
Where there is a one to many relationship you need to decide whether you want the many rows from the linked table or just a single row, such as the most recent, from the child table.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
ray.wurlod wrote:If they're all in the same database, join them with SQL; you may require outer joins depending on the exact relationships.
If they're from disjoint databases, you can use the ODBC stage's multi-row return from lookup capability.
Join them with SQL.... using the "Join" stage in DataStage?
Eric