DSXchange

Hi
Ensure that the xpath is mentioned correctly in the column derivation.
Also check the key values.

You can also search posts here related to XML parsing.
Post the error / warning message so that we can identify the issue.

Hi Sunitha,
There are posts in this forum with many links that will
give you a good overview on the exam and preparation.

Doing a search will help you a lot.
All the best for your preparation.

Hi, Is there any specific reason why you dont want to use aggregator stage? You can defnitely use a transfomer stage to find out the max value. But the data must be sorted before and sent to the transfomer in a sequential order. There are some resolved posts where similar logic has been discussed. T...

Hi
mahadev.v has provided you a solution.
have you tried it ?

As Craig mentioned, you need to analyse the warning message.
Your routine has returned a value that is non-zero and datastage thinks that this is some error code/message returned from routine.

Hi, is your target column Nullable in database? please verify that by inserting NULL values using a sql statement outside Datastage. And when you do conversion functions, you need to handle NULL values. If your requirement is just to load the source data to target without any transformations, then I...

Hi,
There are lot of posts about obtaining job information.
Do a search on DSjob commands.

Also, read up the manuals for DSjob commands.
You will get all the details required.

SELECT CUSTOMERID,CUSTOMERNAME FROM CUSTOMER WHERE CUSTOMERID=ORCHESTRATE.EMP_NO AND ORCHESTRATE.STDATE >= (to_char(RECEFFDATE,'yyyymmdd') and ORCHESTRATE.STDATE <= to_char(decode(RECENDDATE,'',sysdate,RECENDDATE),'yyyymmdd') Hi, 1) your date comparision is incorrect. You are comparing strings here...

Hi,
Can you explain why you are doing DecimalToString and StringToDecimal?
I dont think these stage variables are required.

can you elaborate what you are trying to achieve?

Hi Sunitha

are you using Upsert mode ?
Check the key columns you have mentioned in Oracle stage and the keys in the oracle database.
Are any records getting updated or so you see any warnings in the job log ?

Hi Sunitha,

There are lot of posts in this forum where the same topic has been discussed and resolved. Do a search.

The issue could be with Null values or with length of the string.
Do appropriate Null handling.

'Autopurge' will clear up the log files as you expected.
But what I understand is that you want to remove the job status list.

You can try doing a 'job reset' command at the beginning of a sequence
execution.

Hi Novak
The scenario you explained is not clear.
are you trying to add values or map one i/p value to another key value in target ?

I can get yesterday's date in a stagevariable using the code: Oconv(@DATE-1,'DYMD[2,2,2]') -----> Prevday; But how to get the above in a job parameter? How are you calling this job? if you are using a sequence, you can use 'user variables' stage to get the date and use this as input to your job par...

Hi,
Please give more details.
Can you try using a reject link to the Oracle stage to obtain the sqlerror. This will provide exact reason why the record is not interted.

also mention the exact warning message that you are seeing in the log.

pavan_test wrote:Hi All,
if there is only 1 bad record it rejects all the 100,000 records with a sql code 1403.
Mark

Hi,
Can you explain more on this.