DSXchange

I will suggest you to use the QualityStage to perform that as you can customize the pattern as you wish.

What is the C++ compiler version you used in the Production and UAT environment?

Hi all, thanks for the suggestion. I manage to solve it using the DataStage.
I use the transformer loop to populate all amount into a lists with delimiter, then use field inside the second transformer loop to calculate the sum. Thanks you very much for all the clue.

Thanks all for the input. Sorry for the confusion chullet, the last row is the sum of the amount for the past 7 days only. I have sort the record by customer and transaction date but still no idea how to do a sum for only pass 7 records. This is just one of the scenario and I also have the similar t...

Hi all I have the following request: CUST TX_DT TX_AMT TOTAL_TX_AMT_LST_7_DAYS C1 01-Jan-14 50 50 C1 02-Jan-14 10 60 C1 03-Jan-14 11 71 C1 04-Jan-14 15 86 C1 05-Jan-14 10 96 C1 06-Jan-14 14 110 C1 07-Jan-14 10 120 C1 08-Jan-14 11 81 C1 09-Jan-14 13 84 The last column need to generate per transaction...

Information limited.

1. DS Server has DB2 installed?
2. What is the result of client connectivity from DS server to DB2 (without through DS)?

Out of memory for the stage variable, what is the heapsize value?

Have you tried telnet 9080 from your client to the server?

Have you tried IsNull(DSLink8.State_desc) for the link DSLink8.State_desc = " "?

What is the URL you entered that causing you received the HTTP 404 not found?

Hi Ray Sorry for the confusion, it was zero-length string (""). In the reference file, we have assigned a location ID for the "" value. Whenever the input records have "" value, it will get that assigned location ID for it. This terminology was working fine when in Serv...

Hi I have a job with a Lookup stage which will lookup for the location ID from a reference file. When my input is "" (blank), it cannot retrieved the location ID which assigned for the value of the "" (blank). Anyone face this before and any solution for it? Please advice. Thanks.

Hi all I am trying to install the InformationServer v8.5 into the zLinux box. I have finished the installation but when trying to compile a test job with row generator -> transformer -> peek, i got the following error: Output from transformer compilation follows: ##I IIS-DSEE-TFCN-00001 16:54:20(000...

Validate your configuration node then you might get some message from there.

You are not allowed to change the data type within the Surrogate key generator. The key generated will be in uint64 and you might need a transformer/modify to change the unicode integer to the normal integer.