DSXchange

Would you like to try my script to get metadata from a DSX file?
(max 1Mb)

http://www.dsx.too.it

Geppo

Hi Kevin, you're right, my tool doesn't work fine like a professional tool, infact it is a workaround designed to resolve our specific issues... (the team developed the DataStage jobs without following the metastage guidelines, like for example to use table definition). However using my tool I've ma...

Hi all, I've developed a tool to retrieve the metadata from a DSX file. This tool let you to get automatically some information about datastage jobs, like: 1) Job Category; 2) Job Name; 3) Stage Type (i.e. Table, Flat File, XML file); 4) Source/Target Type (just for TABLE stage type); 5) Stage Name ...

Ok Kevin,
thank you...
I'll check it and then I'll try to describe better the result.

Ciao, Geppo.

Hi Kevin, I try to explain my problem: when I run a sql statement for datawarehouse loader, I need to use a "group by" clause; I just do it by an ORACLE OCI8 writing the statement into the USER-DEFINED-SQL (there is a TAB in the OCI for this)... Now, in metastage, when I run the import pro...

Hi all, I' ve an important question for all the METASTAGE GURU... The question is: I've understood that MetaStage doesn't work fine if the DataStage job doesn't follow some hard guidelines like: 1) mapping Table Definition in the job, columns by columns; 2) do not use USER DEFINED SQL in OCI stage; ...

Hi Wolfgang, sorry but we don't understan what you mean. We try to set "Disabled" (and "Disabled, Lock for Updates") the "Pre-load file to memory" menu in the "outputs" of hashed file but it doesn't works! We're right? Thank you Geppo Hi Geppo, don't mind this...

Hi everyone, we are finding a solution for the following problem: we are using DataStage 5.1 we have a lookup on a target table with an hashed file. We'd like to insert a record in the target table and we want that this record is immediatly visible (stored) in the lookup hashed file. In this way if ...

Do U know how can i link a Table Definition to a Job, without loading the column in the definition of an OCI.
Thanks
Geppo

I need to write on a XML file Output the number of the total record that i will insert on the file, Do U know ohw to do it, and if it's possible??
Thanks