Join tables on multiple columns and pull matching data.

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
Raju_6609
Premium Member
Premium Member
Posts: 19
Joined: Mon Aug 06, 2007 5:15 am
Location: Bangalore

Join tables on multiple columns and pull matching data.

Post by Raju_6609 »

Hi,

I am looking for a better way to do this task.

I have two tables (1 is main table which has details and other one table is summary) which has each 11 key columns as common.


I have join these two tables using these common columns and pull data pertaining to Detail table and Summary table.

Can it be done using hash file(hex) ???


Please help me.
-Raj
dsdoubt
Participant
Posts: 106
Joined: Sat Jul 15, 2006 12:17 am

Post by dsdoubt »

Yes. Load the summary data into the Hashed file. Mark nall the 11 fields as Key. Do a lookup on the Hash file.And extract and join the rest of the fields.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

And you're sure this will be 'better'?
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

What do you mean by "(hex)" in the original question?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply