DSXchange

Posted: **Wed Mar 21, 2012 11:33 am**

How to Perform Cross Join in datastage

Posted: **Wed Mar 21, 2012 12:58 pm**

What have you tried?

Posted: **Wed Mar 21, 2012 3:14 pm**

When's the interview?

Posted: **Wed Mar 21, 2012 5:59 pm**

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

Is that a question or a statement?

Posted: **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.

Posted: **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.

Posted: **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