DSXchange

I think the function JulianDayFromDate may help.

It may be a software installation issue.

You may also try with DECIMAL(15,0) and not INTEGER(15,0)

Are the server name and user name same?

If the output column definitions from all the 4 aggregated links are same, then its better to use funnel, else use a join stage.

I am not aware of any... Are you facing any problem in implementing the lookup file???

You can create a file having all the months(month number, month name) and lookup into it with the month number to fetch the corresponding month name.

The derivation should not start with $ for job parameters in a transformer stage

Read the input records into a transformer stage. Now give 2 output columns: Cash_receipt_id: Populate the input Cash_receipt_id Amount: If Status = Cleared Then Amount Else (-1) * Amount Now add the Amount field group by Cash_receipt_id in aggregator stage and you will get the desired output. Note: ...

Is the data coming in any sequence/sort? Is the case deals with comparision between every 2 successive record? What happens to the 6210 event record? Please clarify these doubts to help you.

From the example that you gave, I think will have only 2 columns in the output

Customer name: /customerlist/customer/customername/text()
Customer type: /customerlist/customer/customertype/text()

If the surrogate key stage is not available to you, you may take the help of stage variables present in the transformer stage. SV + 1 : SV (Initialize it to 0) Move this SV into your surrogate key column. So, when the first record comes the SV is set to 0. After executing the above statement, the va...

Please have a look at the following design- Input rejected records -> Transformer1 -> Funnel1 -> Transformer2 -> Funnel2 -> Reject Table Load I am taking the following records for example. Input record Key1 Key2 Field1 Field2 Field3 Field4 Field5 Correct K11 K21 F11 F21 F31 F41 F51 Reject1 K12 K22 F...

The table could be in load pending state. In that case you may need to release it. I would also like to know which database you are using. I mean to say if you are using a native stage for database loading then it would give better performance. Indexing on the update key column may also play a vital...

You can check with the ASCII values