Topic
  • No replies
venkat_Jey
venkat_Jey
1 Post

Pinned topic Cross Join using Datastage

‏2013-10-28T02:43:01Z |

Hello,

I just started using datastage from yesterday after my training and ran into an issue already.

I m using the datastage8.7 with DB2 as the backend.

I wanted to create two rows of emp id for every month from last year.

EMP ID

0

100

 

MONTH END DATE

01-01-2013

02-010-2013

 

RESULT Table.

 

MONTHEND DATE       EMP ID

01-01-2013                   0

01-01-2013                  100

02-010-2013                 0

02-010-2013                100

 

so im getting the emp ID from a text file using a sequential stage and using the dB2 stage to get the month end date from the calendar table.

How can I create a cross join or cartesian prdouct using the datastage.

I tried the Merge stage but it doesnt seem to work since it throws an error due to an unmatched key column.

your suggestion would really help me.

Thank you