DSXchange

Please can any one help me in creating a table definition for a spread sheet data....

I do not know the procedure.

Thanks
aschand

aschand wrote:Please can any one help me in creating a table definition for a spread sheet data....

I do not know the procedure.

Thanks
aschand

save spred sheet in the format of .csv and create as medata like sequential file.

i saved it as .csv file... then how do i do the rest of the thing

thanks
aschand

In the designer select tab 'Import', within that 'Table Definitions'.

Select the directory in which the csv file resides.

Specify the csv file you want to Import Table Definition.

Select Appropriate 'To Category' and then Click 'Import'.

Specify the general format on the Format tab. Don't forget to specify first line is column names.

You can click preview to view the data.

Then switch to the Define tab (which is what enables the OK button) and correct the data types guessed by DataStage and add data elements and descriptions for the columns. Click OK to save, then open the newly-imported table definition and add a meaningful short description and any useful additional information in the long description.