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.
MONTH END DATE
MONTHEND DATE EMP ID
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.