DSXchange

Hi, I am trying to load a table with truncate option. But the job got aborted and table got loaded with out truncating the data. Should I change any environment settings? I am getting the following error: Oracle_Enterprise_1,0: The call to sqlldr failed; the return code = 256; please see the loader ...

Hi I developed a job using web services transformer stage. Which invokes the getCityTime() service and stores the result in a flat file. I am getting the following error. Web_Services_Transformer_1,0: Fatal Error: Fatal: <ns1:Fault xmlns:ns1="http://schemas.xmlsoap.org/soap/envelope/"> <fa...

Hi Pravin,

Use Merge stage instead of Join stage. The reject link in merge stage gives all the rejected records.

Hi
Use Copy stage after join stage. In each output link select only the required columns.

To Get the maximum timestamp, Use Sort stage and Remove duplicate stage.

Hi , I am using a transformer to perform some validations, and then processing all error datasets using a funnel stage, which then links to a single error dataset. When I am running the job, I am getting the following warnings. Funnel_19: When checking operator: Dropping "FHAN62_CMY_CD" in...