DSXchange

Nagarjuna, Thanks for reply.

So there is no way that we can do this from DS functions?

And one more thing other than the position is, there is a comma with in the fullname part. so using comma as delimiter in field function will remove the second part in FULL NAME.

The position of these name fields in the string is not same for each record they keep on varying like the following sample 3 records. "EMP_FIRSTNAME=LATHEEF SYED","EMP_LASTNAME=HUSSAINY","EMP_FULLNAME=HUSSAINY, LATHEEF SYED" "EMP_FIRSTNAME=CHISTINE","EMP_...

I have a sample data like this "EMP_BASE_RATE=8.81","EMP_BIRTH_DATE=08/03/1987 00:00","EMP_FIRSTNAME=MANUEL","EMP_LASTNAME=BUENO","EMP_FULLNAME=BUENO, MANUEL","EMP_PAYGRP_NAME=PHASE1","EMP_SIN=removed","EMP_FLAG3=N",&quo...

I have a sample data like this "EMP_BASE_RATE=8.81","EMP_BIRTH_DATE=08/03/1987 00:00","EMP_FIRSTNAME=MANUEL","EMP_LASTNAME=BUENO","EMP_FULLNAME=BUENO, MANUEL","EMP_PAYGRP_NAME=PHASE1","EMP_SIN=removed","EMP_FLAG3=N",&quo...

Can any one let me know how to capture the reject rows while updating using DRS stage?

I have project for which i need to do small changes. So i exported the dsx and done changes and then was importing. But suddenly in the middle of import (after some jobs are imported) it said the connection is lost and i have to hit the OK button with error for each job until end. After this i kille...

Hi, Like we have multiple job compile, do we have a multiple job run? I don't want to press the run button for each job. I know we can use sequencer for this. But i am looking for which i can do this without sequencer. For each table i have 2 jobs, job1 and job2. I want all the job1s to run/execute ...

I have a job set up like Dataset------------->transformer--------->Oracle stage. I update some columns using key columns in the oracle tables (upsert). Can you please let me know, if there is anyway to make sure that each update statement updates only one row. I know that if the keys are unique it w...

Thanks Craig,

I can implement this....but do i need to have RTI components for this? since the source and target tables should be in sync always.

Thanks Craig,

I can implement this....but do i need to have RTI components for this? since the source and target tables should be in sync always.

some advice please....

I am new to Real time and that is the reason i am asking this question

Hi,

I have an requirement where i need to sync two tables with different layouts in two different instances (oracle to oracle). How can we invoke this in real time mode? What should i need for this. Please let me know.

Thanks

Hi,

I have an requirement where i need to sync two tables with different layouts in two different instances (oracle to oracle). Can we do this in real time mode? What should i need for this. Please let me know.

Thanks

Hi...Thanks again for the inputs and it is working for different lengths. Now i have a different scenario....Apart from header and trailor there are some files with detail records having different lengths. This is making difficult to cut down the single column into multiple columns in a particular f...