Join in server

chandra · Post by **chandra** » Fri Apr 21, 2006 12:32 pm

in 7.5 server we dnt hv stage called JOIN ,then how do we achive the join server Jobs & is tha possible to run parllel Jobs in Server .
tnks in adv

DSguru2B · Post by **DSguru2B** » Fri Apr 21, 2006 1:32 pm

1.You can used the Hashed file stage to do the joins.
2. You cannot run parrallel jobs if you only have Data Stage server edition.

diamondabhi · Post by **diamondabhi** » Fri Apr 21, 2006 2:55 pm

As dsguru said u can use hashed file stage. Please post what you want to do exactly?

ray.wurlod · Post by **ray.wurlod** » Fri Apr 21, 2006 3:39 pm

You can also use a Merge stage if both sources are text files and there exists a common key.

sb_akarmarkar · Post by **sb_akarmarkar** » Mon Apr 24, 2006 2:50 am

ODBC Satge also.
write join query in ODBC stage itself.

Thanks,
Anupam