How I can do Cross Join

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
snassimr
Premium Member
Premium Member
Posts: 281
Joined: Tue May 17, 2005 5:27 am

How I can do Cross Join

Post by snassimr »

Hi , everybody !!!

I have two files and I need to get CROSS JOIN Between them . How I can to perform it .

Thanks
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Merge stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
snassimr
Premium Member
Premium Member
Posts: 281
Joined: Tue May 17, 2005 5:27 am

Post by snassimr »

What Join Type to use there ? It seems none of existing Joint types don't give me the cross join
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

From what I recall, the "Complete Set" join type should be what you are looking for.
-craig

"You can never have too many knives" -- Logan Nine Fingers
nandwana_chetan
Participant
Posts: 3
Joined: Fri Oct 31, 2008 8:10 am

Join command of unix

Post by nandwana_chetan »

Hi you can use join command of unix . here you can specify key columns and you can do it easily
Chetan Nandwana
SE Capgemini
Post Reply