DSXchange

Hi i have 700 columns in target side and 400 of them do not have data nor the source columns to be linked... so what should i do such that i can replace the empty dervation columns with Setnull() at the target

Thanks for your help
aschand

Here is the example ABCD_EFGHI source side EFGHI target side now what should i put in ignore prefix inorder to auto match the column? Thanks for ur help Can you give some example.. like what??? You can use Trim, or do substring and or many other functionality avaiable based on the exact requirment. ...

Please can let me know how do I ignore prefix in the iput columns to map to o/p columns in the transformer stage..
What to write in it

thanks
aschand

Thanks for your reply.... But here the source is SQL Server... So how do I load spreadsheet data into SQL Server using Datastage Parallel job? If source is spread sheet then just use the SEQUENTIAL FILE stage and link to database stage. do your transformation in any appropriate stage or use transfor...

Hi,

Can any one please explain me the procedure of loading a spread sheet data into a SQL Server with the table created already in the SQL Server using Datastage where SQL Server is the source.


Thanks for your Help
aschand

Can any 1 please help me by telling how to run scripts of a job which is already created in Datastage and has to be run by me in my machine... everything remaining same...

where to place the script?
How it looks and how do i do it right from step1?

Thanks for your help in advance
aschand

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

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

thanks
aschand

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 ...

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 ...

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

hi

Can any one please explain me how to create the alignment table from a single spread sheet in datastage 8.0.1 parallel edition
please it is very urgent

Thanks in advance for your help
aschand