DSXchange

Thanks for the response.

I have not used this. Can you please give some more details as to how to do this. This will be of great help for my project.

I have a flat file as source, which is coming from a mainframe system. One of the field in this file is a packed decimal. Can anyone tell me how to extract this field and load it in to an oracle database as a normal decimal.

varchar(1500) is valid and I have used this before... but I had aproblem when I used a column with datatype varchar(4000). This was not giving any error or warnings but it was inserting spaces into the target. This was resolved when I changed varchr ro char

Use dsjob command in crontab to schedule.

e.g.

A recored with two columns: 'ABC1', 5

I want the output to be

'ABC1'
'ABC2'
'ABC3'
'ABC4'
'ABC5'

The number of output rows is based on the value of the integer coloumn.

Try changing your datetype in the target stage to timestamp. If you don't want the "HH:MM:SS.SSS" part trim the source before loading it into the target.

I have two columns coming from the source (Oracle10g Database), one is a varchar and another interger. I have to generrate multiple rows for each rows coming from the source based on the integer column. Can someone tell me how to do this in Datastage.