alignment tables ....

aschand · Post by **aschand** » Sun Jan 06, 2008 12:35 pm

hi

Can any one please explain me how to create alignment table from the spread sheet in datastage 8.0.1 parallel edition

Thanks for your help in advance
aschand

ArndW · Post by **ArndW** » Sun Jan 06, 2008 12:46 pm

It seems that you don't consider READMEs to be worth reading and that the use of the builtin search engine isn't of any interest to you either.

Perhaps you can rethink your urgency and why it should affect the members of this forum.

In addition, the concept of an "alignment table" is not a general IT one; meaning it is most likely some term specific to your implementation and you won't get any useful replies unless you explain what you are looking for detail.

aschand · Post by **aschand** » Sun Jan 06, 2008 1:02 pm

hi

im new to this DSXCHANGE forum and regarding my request... it is that to create a table called alignment table from where i can get all the spread sheet data and can make it as a source table in DS

the alignment table stages the data without any changes... it groups or collects same type of data together and creates an id for it...

now my question is how to get that spread sheets data into a table

thanks
aschand

ArndW · Post by **ArndW** » Sun Jan 06, 2008 1:25 pm

So your question is how to read Excel table from Windows DataStage.

Declare the Excel sheet as an ODBC system DSN and read it from a job.

aschand · Post by **aschand** » Sun Jan 06, 2008 1:41 pm

Thank you... but can you please be more clear to understand exact process as im new to datastage also

thanks
aschand

ray.wurlod · Post by **ray.wurlod** » Sun Jan 06, 2008 3:17 pm

Setup an ODBC System DSN (not a User DSN) uing the ODBC driver for Excel. Select the Workbook that you want to access. This step has nothing whatsoever to do with DataStage - it is performed with the Windows ODBC Administrator.

In DataStage import the table definition for each worksheet that you wish to interrogate. Note that Excel presents worksheets as system tables.

Design a DataStage job that reads rows from the worksheet and disposes of those rows in accordance with your specification document (for example a source-to-target mapping).

ray.wurlod · Post by **ray.wurlod** » Sun Jan 06, 2008 3:23 pm

Procedural Note

We don't do "urgent" here and that goes double for Sundays. If you want "urgent" sign up with your support provider and learn the true cost of "urgent". DSXchange is an all-volunteer site whose participants post as and when they can.

Premium Membership

Premium membership costs less than 30c per day and allows you, among other things, to read the complete posts of the premium posters, which often contains the solution you seek. Revenue from premium memberships is 100% devoted to the hosting and bandwidth costs incurred by DSXchange.

aschand · Post by **aschand** » Sun Jan 06, 2008 3:42 pm

ray.wurlod wrote:Setup an ODBC System DSN (not a User DSN) uing the ODBC driver for Excel. Select the Workbook that you want to access. This step has nothing whatsoever to do with DataStage - it is performed with th ...

hi im not a premium member...so can you please tell me how to see what you have posted completely

ray.wurlod · Post by **ray.wurlod** » Sun Jan 06, 2008 7:16 pm

Enrol as a premium member.

Premium membership is one of the ways that this site is funded. I am neither inclined nor prepared to prejudice that; I find this site too useful to allow it to die through lack of funding. To make even one exception would create an unacceptable precedent.