DSXchange

I need to read the few colums from a '|' delimited sequential file. File may have any number of colums.

We can do this by using the partial schema file. I want the syntax for creating a partial schema file.

Example in help pdf is for fixed width file not for a delimited file.

Thanks Ray. why do we have an option in paralllel jobs for setting these parameters ?

We have a option of enabling the row buffering in DataStage Administrator. It gives us two options : In Process and Interprocess and Admin guide suggests that it helps to improve the performance. I can't understand how this option increase the performance of DS jobs. Can someone explain me the about...

Hi,

Please give me extact syntax for using the close command in oracle enterprise stage.
I am trying to execute a stored procedure after loading the data in the table but it is giving invalid close command errror.

I am using the statement

'exec proc_name;'

Please help.

Hi ,

I have defined datatype as varchar for the columns and using datasets as source and target.

Hi All,

I am getting the below error while executing the job.

Slowly_Changing_Dimension_3,0: Input buffer underrun; traversed 88 fewer bytes than present in the record buffer.

Please suggest a solution.