DSXchange

Hi All, Please let me know if I am trying to concatenate two columns from source and loading into target as single column. On source side, one column having value other one is maybe null. Usually if we add string with null we get null. How can we overcome this problem? we are using 7.1 server Thanks...

Hi All,
Please let me know what is e*Way Intelligent Adapter for sap(BAPI)

Shall we use this one in Datastage to connect sap .

Thanks & Regards
Ram

Hi, Can any one tell me how to craete a before job subroutine using basic functions for data cleansing. I need subroutine code for data cleansing. Thanks, Somaraju Hi , In job properties window you can mention before subroutine and after subroutine. Pls correct me if it is a mistake. Regards ramdev

Hi all, We are facing one problem in removing duplicates. we have 2 files. Each file has 10 million records. When we remove duplicates using Aggregator stage on 3 key columns, we are getting limitation on Aggregation memory. The job is getting aborted after the memory reaches to 2 GB, i.e after 15 ...

HI, I have a table CODE VARCHAR2(10) PK NOT NULL, CODE_DESC VARCHAR2(50) If I do a userdefined query in a OCI stage and write to a file with the following command SELECT CODE FROM CODE_LKP it works. If I perform the same in a job where this stage acts as a lookup, it gives me the following error. O...