How to Perform Cross Join in datastage

sudha.gundap · Post by **sudha.gundap** » Wed Mar 21, 2012 11:33 am

chulett · Post by **chulett** » Wed Mar 21, 2012 12:58 pm

What have you tried?

ray.wurlod · Post by **ray.wurlod** » Wed Mar 21, 2012 3:14 pm

When's the interview?

stuartjvnorton · Post by **stuartjvnorton** » Wed Mar 21, 2012 5:59 pm

sudha.gundap wrote:How to Perform Cross Join in datastage

Is that a question or a statement?

sudha.gundap · Post by **sudha.gundap** » Wed Mar 21, 2012 6:40 pm

@chulett : Have tried it through full outer join in Join stage and it worked.
previously i thought it won't work and posted for suggestions to do it in some other way....

@ray.wurlod: Not an interview.... working for a firm... Thank you....

@stuartjvnorton : It's Obviously a Question.

chulett · Post by **chulett** » Wed Mar 21, 2012 7:59 pm

sudha.gundap wrote:@chulett : Have tried it through full outer join in Join stage and it worked. previously i thought it won't work and posted for suggestions to do it in some other way....

All good information to have included in your original post. Without it it just looks like an interview question.

sudha.gundap also wrote:@stuartjvnorton : It's Obviously a Question.

Not without a question mark.

qt_ky · Post by **qt_ky** » Wed Mar 21, 2012 8:31 pm

Search this site on "Cartesian product"... here is one such topic:

viewtopic.php?t=142371&highlight=Cartesian+product

DSXchange

How to Perform Cross Join in datastage

How to Perform Cross Join in datastage

Re: How to Perform Cross Join in datastage