DSXchange

Hi All, I need a clarification with respect to remove duplicate stage. Scenario 1: Job Design: Source Dataset ---> Sort stage ----> peek stage As we all know, using sort stage we can remove the duplicates. In this case when I checked $APT_DUMP_SCORE of my job I could not able to see separate operato...

Just to be clear, when you say "pound symbol" do you mean the currency symbol (₤) or the sharp sign (#)? ... Hi Chulett\Ray Apologies for the late response we are using datastage 8.0.1 OS is UNIX NLS is not installed. Job Details, we are receiving price information for the products in the...

Hi Dawar,

We are also facing the same problem, we are getting pound symbol from source xml, since NLS is not installed we are not able to convert the pound symbol.

Hi ray,

can you please advice us if any workaround for this issue.

Thanks,
Ram.

Hi SURA,

No issues, thanks for your clarification, i will ask my admin to track the memory utilization.

Thanks,
Ram.

Hi Sura,

i tried with your approach but still i am geting the same error message.

Thanks,
Ram

Hi SURA,

Thanks, i will test the job by using the above variable and let you know the outcome.

Thanks,
Ram.

Hi All, Issue: we are encountering a new issue with Join stage while combining the header and detail xml record. Error Information: node_node2: Player 22 terminated unexpectedly. main_program: APT_PMsectionLeader(3, node2), player 22 - Unexpected termination by Unix signal 11(SIGSEGV) Additional Inf...

In transformer create two output links for two datasets, inside transformer in the output link include the above two transformation link1 ---> ISNOTNULL(SHOP_ID) AND ISNOTNULL(SHOP_DESC) AND ISNOTNULL(DEPT_ID) AND ISNOTNULL(DEPT_DESC) for getting the below output NULL,NULL,NULL,NULL NULL,NULL,NULL,N...

Hi kalpana, use the following the derivation in the transformer constraint CAPTURING THE VALID RECORDS ISNOTNULL(SHOP_ID) AND ISNOTNULL(SHOP_DESC) AND ISNOTNULL(DEPT_ID) AND ISNOTNULL(DEPT_DESC) CAPTURING THE INVALID RECORDS: ISNULL(SHOP_ID) OR ISNULL(SHOP_DESC) OR ISNULL(DEPT_ID) OR ISNULL(DEPT_DES...

Hi, check the format of the input value StringToDate(Eff_Dt,"%yyyy%mm%dd") for example %mm% is getting value 15 from source file means wrong because maximum month value is 12, so validate your input, one more thing for null field column you cannot directly use the transformation functions ...

Hello Ramsubbiah, Follow Ernie suggestions ... and please try increasing the number of messages that you are expecting to unlimited Wait time = -1 message quantity -1 end of data message type = 9999989 Record Count = 0 End Of Wave = After End Of Data = Yes Regards Hi Julio, if i change the message ...

ray.wurlod wrote:Is this an Information Analyzer question?
...

Hi Ray,

sorry wrongly i have created this topic under this forum, please tell me how to move this topic to datastage parallel forum

Thanks,
Ram

Not sure if there is an issue? .....sounds like it is working great... ...but of course, for a real time job like this, you should have a single node configuration. Then, if you browse, you will get only one copy of the message, not multiples. There are only very rare cases when a real time job nee...

Hi Ernie/julio,

Thanks for your information, i will re test the job based on your findings and get back to you shortly,

Thanks,
Ram

Hi Everyone, i have a requirement to develop a job which will fetch the files from source Queue whenever file arrives , so i have created the following job design for testing, MQ----->TRANSFORMER------->Dataset in the MQ stage i have given the following values for the parameters Wait time = -1 messa...