Page 1 of 1

Join in server

Posted: Fri Apr 21, 2006 12:32 pm
by chandra
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

Posted: Fri Apr 21, 2006 1:32 pm
by DSguru2B
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.

Posted: Fri Apr 21, 2006 2:55 pm
by diamondabhi
As dsguru said u can use hashed file stage. Please post what you want to do exactly?

Posted: Fri Apr 21, 2006 3:39 pm
by ray.wurlod
You can also use a Merge stage if both sources are text files and there exists a common key.

Posted: Mon Apr 24, 2006 2:50 am
by sb_akarmarkar
ODBC Satge also.
write join query in ODBC stage itself.

Thanks,
Anupam