DSXchange

Hi Eric,

I did not review the work done by my team on using the Change capture stage..

but told its worked .. let me check the same and will revert if its worked or not.

Regards,
Cheru.

pandeesh wrote:I believe you can use change capture stage for this.

---

I tried using change capture stage and it worked as expected

Thank you for the help..

Hi,

Please revert me with the solution for the requirement above.

Regards,
Cheru.

pandeesh wrote:It looks like, do you want to achieve insert/update mechanism in sequential file?

YES its an INSERT/UPDATE mechanism in file.. please explain me.. thank you.

Hi I have a requirement like the datastage job should automate to run for every 5 mins. first time the job is run and file loaded in /tmp/target/ and second time when it run the new file should check the key value on the existed data (that was run before) and if no key value exists then the record s...

Hi, I have a requirment as explained below: Question : Daily files are placed in '/tmp/ds/sources/' the files are in .csv formate I have to dev a Datastage job (and load to the path '/tmp/ds/target/') in such a way the job should run daily and should pick the present date file, if i did not get a fi...

Hi,

I myself investigated the root cause for the same.
I have renamed the stage name xfm to xfmActiveRules (a different name)
and compiled -> executed and job executed successfully with expected output ........ Thanks you all for viewing my question and tried for helping me.

Thanks You.
Cheru.

Hi, When i tried executing the job I am getting this error below , please suggest me how to correct this error. Xfm: Failed to load the library "V0S1_PAR_LOAD_ALG0_EQUI_EQUT_EQUZ_ILOA_Xfm.so"; either the directory containing the library file is not on the library search path, or the librar...

I have a text file which contains the names of few job sequences new line delimiter. Now I am developing a sequence job which will only run those sequences whose names are retrieved from the text file. (i) I call an script which gives me the names of the sequences. (ii) I store all the names of in U...

Hi, I have a text file which contains the names of few job sequences new line delimiter. Now I am developing a sequence job which will only run those sequences whose names are retrieved from the text file. (i) I call an script which gives me the names of the sequences. (ii) I store all the names of ...

hi Arun,

Thanks, for a quick solution it worked.

Hi, Please give me a solutions for the below question: my input data : filed1 1.223 0.003 45.89 0.00006 45.8934 My output data : field1 field2 12.23 10 0.03 10 45.89 1 0.06 1000 4589.34 100 so the out put data should be rounded to last 2 decimal places as an example shown above. and also need the va...

Hi,

Please give me a solution for the below question:

input data is like :

field1

ABC-123-BG-
NMKL-
QWER-FR
GHK-RTY

I should get the out put as :

Field_output

ABC-123-BC
NMKL
QWER-FR
GHK-RTY


Please help me how to search the last character '-' and trimming it..

Thanks,

Cheru.

Hi, I have a input source like : Field1 ------- 02102;9;988 4;8;8942333 09323;2;6700 874;34;2323 How can I get the data between ;'s the output file should be like: Field1 -------- 9 8 2 34 so the output file should contain the data between the ;'s of the input file. Please tell me how to do this. Th...