DSXchange

Input 2 is already sorted but not partitioned in the previous job while creating dataset . So , If i am using a hash partition before sort stage ( don't sort already sorted ) will not disturb the sort order ? Here I am using same partitiong on the both the links of the join stage .

Hi All , I have some basic question about join stage . The design of the job is as below Input1:comes from oracle enterprise stage select col1 , col2 , col3 , col4 from table Input2: dataset ( dataset is generated in previous job with design Oracle enterprise ---> Sort Col1 , Col2 --> Dataset ) Inpu...

can you please elaborate the requirement ? IN operator can acheived by filter stage .

if you have the copy books ..import those table definitions and see if you have given it correctly in CFF

This is a problem of c++ compiler i guess ..try to set apt_compiler_opt and apt_compiler variables correctly ..

use file pattern and after that extract filename the file . Use this filename in transformer constraints to segregate the records ..in derivations use these n add another column ..

Hi Mike ,

Thanks for your response..Just wondering if any one has a utility to convert a DML file into datastage schema file ..

Ok now I got DML file in abinitio .Now how to convert that DML file in abinitio to datastage schema file ??

They are using abinitio to dump the files .But there are no headers for the files ..

Thanks a lot Ernie for giving more inputs . Ray , I do know that i need to have access to the table . Here I am trying to understand if there are any other ways . May be i should have explained in more detail .... I am getting a bunch of files , which I need to read,format , transform and load into ...

Is there any way to create a schema file from the DDL script ??

Unfortunately I don't have select access from datastage server . I have select access from local desktop . So any other suggestions ??

Hi All , I am trying to import the table definition into datastage . But I dont have access to the oracle table which I am importing into datastage . I have DDL script for that table .Is there any way I can import the table definition . I have to do this for 20 tables which are having many columns ....

Hi all, Just wanted to know what is the table name in shared metadata repository (XMETA) which stores information about Parameter set. For example all the datastage jobs are stored in DS_JOBS, routines in DS_ROUTINES, containers in DS_CONTAINERS This is because I need to edit an parameter set in my ...