DSXchange

Hi Chulett,

I need to increment the audit table each time the condition is not satisfied.The audit table is used through out the process.I mean around 10 jobs.In each transfermor I need to incremnt the audit table

Hi All,


How to reset the value to zero for "KeyMgtGetNextValue" before my process runs each time?

I need the below output please let me know how to do in ds


Input
101 1000
101 2000
101 3000
201 1000
201 4000

Output
101 1000
101 3000
101 6000
201 1000
201 5000

Hi Ray,

In the above example I want to check EMPNO and ENAME.IF EMPNO is same and ENAME is 'SUSHMA' and 'HARITHA' Then only I want output EMPNO,ENAME is HARITHA and Remaining all are same.

Hi All, I have one scenario. Could you please Help me the below scenario. INPUT IS EMPNO,ENAME 100,SUSHMA 100,HARITHA 101,SUSHMA 101,SUSHMA 102,HARITHA 103,PUJA 103,PUJA 104,SUSHMA 104,HARITHA I WANT OUTPUT AS EMPNO,ENAME 100,HARITHA 101,SUSHMA 101,SUSHMA 102,HARITHA 103,PUJA 103,PUJA 104,HARITHA In...

Hi.., I want to replace one string to another string by using unix 1.by using vi editor 2.with out using vi editor for ex: I/p is like --------------- sushma is reading books,sushma is watching movie,sushma is cooking.... o/p is: --------- bargavi is reading books,bargavi is watching movie,bargavi i...

Hi,

I have 1,00,00,000 records of data.After loading 65,00,000 data the job has been aborted.

Is there any possibility to load data 65,00,001 onwards not starting onwards in datastage.

If it is possible Could you please suggest me??

Hi Ray,

Thank you for your reply.

In some times my telephone length is morethan 11 degitis
like 9198765432110254

In this example i want output 09876543211 and just ignore after 11 digits
As per your reply i am getting output is 06543211025.

I have one requirment.

My input is

telephoneno
09700020075
919889110102
918571233668

i want ouput is

telephoneno
09700020075
09889110102
08571233668 and length should be 11.If first two characters is "91" i need to replace as "0" in parallal jobs.

Hi All, Ihave one scenario.. I/P is NUMBER,comment 1233,Recharge_ezetop:38949886 4567,ezetop_Recharge:38948263 9868,InvocenTopup -105056 2458,TopupInvocen -104962 5789,SMS-TOPUP 157784640 2568,V-rch by 94788940566 2568,V-rch by 94788940566 I need output is NUMBER,comment,channel 1233,Recharge_ezetop...

Where i have to use above query in datastage oracle connector and how can i define columns PS_DATE,PS_HOUR in columns tab and how can i calculate these two columns?

My input data is I want o/p is

Hi, select PS_DATE,PS_HOUR,SUBSCRIBER_ID,SUBSCRIBER_TYPE,MESSAGE_TYPE,SUBTYPE_ID, CIRCLE_ID,SP_ID,SUBSCRIBER_ID,BALANCE_ID, sum(CHANGE_AMOUNT)CHANGE_AMOUNT,count (*)no_of_SMS from (select VARCHAR_FORMAT(DATE_time ,'DD-MM-YYYY')PS_DATE ,VARCHAR_FORMAT(DATE_time,'HH24')PS_HOUR ,SUBSCRIBER_TYPE,MESSAGE...