DSXchange

Hi all,
Im a new datastage user. we are going to be using the tool for our ETL
process. Does anyone know how I could get some kind of Standards
Documentation in regards to migration, naming convention, and specifications
any info would really be appreciated

Thank. / Tunde.

Hi All Datastage 5.2 r1&2 and Sun Solaris 2.8 I did a clean install of Datastage on Sun Solaris. The installation went fine. Try to register a plugin in DS Manager and you get the following error: Unable to register plugin (Path=/export/home/Ascential/DataStage/Plugins/sybaseoc/solaris/dstage/sybas ...

Hi all, Will Data Stage 5.2 process binary files.Can i use binary files as a source or target Thanks in Advance Rgds Prasad > ---------- > From: Senthil Kumar B[SMTP:Senthil_KumarB@mindtree.com] > Reply To: datastage-users@oliver.com > Sent: Friday, May 30, 2003 8:19 AM > To: datastage-users@oliver....

if you do a search on denormalize in the archive, you will find a way to do this that was posted about two months ago. Otherwise I have a sample dsx you can look at as well. Tim Walsh wrote: >I believe that the Pivot plug-in does the exact opposite of your request. > >Input Data >Header: Sales 2000,...

Use a hash lookup for this.The solution becomes simpler. Just lookup into the hash file for "id". If u find a row insert,if u dont just append that particular row with a comma and the data. Hope this solves the problem -----Original Message----- From: J. Schatz JMS Data Management Inc [mailto:johnsh...

I believe that the Pivot plug-in does the exact opposite of your request. Input Data Header: Sales 2000, Sales 2001, Sales 2002, Sales 2003 Data: 1055.25 , 2030.20 , 150233.12 , 1111111.11 Output Data Year, Sales Amount 2000, 1055.25 2001, 2030.20 2002, 150233.12 2003, 1111111.11 Etienne, To do what...

Etienne You can use Pivot plug-in to do this. Usually Pivot plug-in is not installed in standard set up of DS 4.XX, but it should be available in the DS package. You can ask your DS admin to install it for you. Thanks, Madhu Etienne Dodu To: datastage-users@oliver.com cc: 05/22/2003 01:40 AM Subject...

All, I know I have posted this before, but I thought I would give it another shot. Over the last couple of days we have had sever jobs experience some corruption. The first two incidents were cases where the job when into an unknown state (where the status in director says that the job is running, b...

Hi everybody, Im looking for a routine wich create one export file (.dsx) for each job of an all project. Example : ProjectName : Customer Job1 : InputCustomer Job2 : OutPutCustomer Files created : InputCustomer.dsx, OutPutCustomer.dsx PS : If possible the routine wich import all the filr (.dsx) of ...

Stephane, The import process is fairly easy. Using the command line program DSCMDIMPORT, which comes with the DataStage client, it is fairly easy to build a windows CMD file to import all the DSX files in a directory. Basically, you use the Windows FOR command Eg For %%e in (directory*.dsx) do "c:pr...

This is a topic for an orphaned message.

DataStagers Go to www.Duke-Consulting.com and download DwNav. DwNav allows you to browse the doc_tool.mdb in a clear and precise way. 30 day demo is free. Easy to install. m for the software. m for the manual. m for both. If you are new to a project and need to find the job that updates a specific t...

Thats not a guess, its entirely correct. ----- Original Message ----- From: "David Barham" Date: Tue, 27 May 2003 00:13:40 +1000 To: Subject: RE: same return always > Im guessing it is because DSGetJobInfo, DSGetNewestLogId and DSRunJob all > want the handle, not the job name as the first parameter....

Im guessing it is because DSGetJobInfo, DSGetNewestLogId and DSRunJob all want the handle, not the job name as the first parameter. You code should be: st_handle = DSAttachJob (JobName, DSJ.ERRWARN) Status = DSGetJobInfo(st_handle, DSJ.JOBSTATUS) Warnid = DSGetNewestLogId (st_handle, DSJ.LOGWARN) Ru...

Hello Guys I am using these three line of code for different jobs that have different status (Finish without errors,Aborted,finish with warnings) but these function return the same values (-1) Any Idea Guys why ?????????????? st_handle = DSAttachJob (JobName, DSJ.ERRWARN) Status = DSGetJobInfo(JobNa...