Please can any one help me in creating a table definition for a spread sheet data....
I do not know the procedure.
Thanks
aschand
Table Definition
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 106
- Joined: Wed Oct 04, 2006 5:21 am
Re: Table Definition
save spred sheet in the format of .csv and create as medata like sequential file.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
-
- Premium Member
- Posts: 145
- Joined: Fri Sep 21, 2007 9:35 am
- Location: Boston
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.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.