DSXchange

srekant - instead of getting an explanation that would be a copy of what the documentation states, just do it - run the job and then go into the dataset explorer or use orchadmin to see what the resultant dataset looks like. Column propagation is a wonderful and powerful tool that, unfortunately, c...

If i am runtime column propagation then how will be my target dataset .do i have to manually create the column names. i.e i created a job : Seq Compare Dataset Oracle Enetrprise then how am i going to have my target definition.

hi, I trying to use compare stage .I went to developers guide in it it was given We recommend that you use runtime column propagation in this stage and allow DataStage to define the output column schema for you . but when i practically do it in Datastage 7.5 EE in output tab columns are not getting ...

How can i achieve constraint based laoding using datastage7.5 EE .My target tables have inter dependencies i.e Primarykey foreign key constraints.I want my primary key tables to be loaded first and then my foreign key tables and also primary key tables should be committed before the foreign key tabl...

u can do it by running dsjobreport as an after job routine in your parallel job this will create log information in an XML file. create an other job which reads this xml file (XML file input stage) import the metadata using xml metadata importer when u import u can see the elapsed time,instance id ...

you can achieve it by environement variable $APT_ORAUPSERT_COMMIT_ROW_INTERVAL

You can use pivot stage to do it.

I am using Suroogate Key generator.It is working fine for the current run, but, when i run the same jon the next day it is starting to generate keys starting fom 1.My requirement is it should start from where it left previous day.How can i achieve this.

In Transformer u have the substring function i.e [,],use this function to split the second column in the source i.e [b]Derivation[/b] [b]Columnname[/b] Map as it is from input Field1 split the second column as below DSLink3.FIELD2 [1,3] Field21 (DSLink3.FIELD2[5,7])[1,3] Field22 DSLink3.FIELD2 [9,11...

Hi, I am able to get output as required in DataStage Parallel Jobs using a pivot the design is as shown below I/P------------>Xfm----------------->Pivot------------->o/p(DataSet). I/p is a sequential file and in Transformer(Xfm) i am spliting the second column of input into multiple columns using su...

but my source file is like this A2005 B02 C02 4080,556095100,50000000 4080,556095100,50000000 4080,556095100,50000000 4080,556095100,50000000 4080,556095100,50000000 4080,556095100,50000000 4080,556095100,50000000 4080,556095100,50000000 if i take substr(1,4) then only 3 column will be outputed but ...

Hai, I have a scenario where the source file is of format Source Sample Input Data Year -------------------------- 2002 Month -------------------------- 02 Month ---------------------------02 COMC ---------------------------4089 GROUP ------------------------------511111111 CS ----------------------...

I am getting the following eroor when trying to run the job which have Oracle_Enterprise stage Oracle_Enterprise_1: Can't find version in v$version [orautils.C:587] Oracle_Enterprise_1: GenericQuery:esqlErrorHandler Fetch failed for: GenericStmt_3 query is: SELECT banner FROM V$VERSION sqlcode is: ...

SELECT HORSE,FREEZEMARK,MCHIP,REG_SOC,LV FROM MASTER

above is the query i am executing it is working fine in sqlplus.but when i am using in Oraqcle stage it is giving problem