DSXchange

Hi All Does anybody know how to view the actual call that the Hierarchical stage is passing to an API when performing a HTTP POST command with the REST Step? I am trying to pass a file to an API. I am able to successfully call the API passing the file from the command line using cURL or via other ap...

The multinode/parallel settings were the first thing I checked. Its definitely executing sequentially. More so it executes the multiple calls sequentially also, 3 times, one after the other. I have a theory that its going something to do with RCP and the connector calling the DB to get the metadata....

Hi All I am having a strange issue when using the JDBC Connector to call a Stored Procedure. The job design itself is relatively simple: JDBC ----> Tfm -----> Unstructured (Excel) The only "tricky" part is that it is fully RCP and parameterised. To execute the process I pass one of about 3...

Personally I would tackle it as follows: 1. Split off your column names and create a single delimited string of them all ordered alphabetically CBD|GTI|FUND|SC_ID 2. Join that delimited string of column names back to your original data eg 22 CBD 123 CBD|GTI|FUND|SC_ID 3. Use stage variables to do a ...

No, its not possible

https://www.ibm.com/support/knowledgece ... ource.html

I can only offer the following regarding RCP, and how its worked in my experience. It would seem that it does indeed create everything in the spreadsheet as General (Except dates to which it gives a custom style). However values that were decimals seem to be treated as numbers, and values that were ...

Surely you can just sort your data appropriately and take the first record?

Eg Sort by:
1. Account Number (Asc)
2. Account Status (Desc)

Use a remove duplicates stage with the key Field of Account Number and keep the first record.

This should cater for all outcomes?

Hi All Does anybody know if there is any limit on the number of times a single lookup fileset can be used in the one job, be it an numerical limit (eg 10 times) or a limit enforced by system constraints (eg memory). I ask as we have a couple of jobs which fail periodically, each time the failure is ...

Thanks for the thoughts. I too am looking at the generate the column headers first route as it would seem the only logical way to get around it. But rather than modify the existing file, feed it in via a funnel, its just a matter of determining how to generate the column headers from the input SQL/s...

Hi All I am having an issue whereby when using a target Unstructured File Stage to write to an Excel file, with RCP enabled on all stages, that the target stage is renaming the column names. The job itself is quite simple: DB -----> TFM ------> EXCEL The DB executes a query The TFM is a placeholder ...

Parameterise the specification value and pass either your required keep statement or the phrase NOWARN

As per chulett's suggestion, this can be done relatively easily with a transformer and looping. You will however need to be able to provide the number of columns required to the output (also any column names if required). Using that number of columns you just build up a delimited list of values for ...

Broadly speaking, you could do the following: 1. Sort your data by the ID and the Date (Desc). 2. Determine when the key field changes. 3. Set up stage variables to capture Cur_Loc, Pre_Loc, Cur_Role, Pre_Role 4. Derivation for each stagevariable would be something like: If KeyChange then If Not(IsN...

What have you tried so far?

HINT: Set stage variables and compare

My requirement is to get a single column output(say Col2), with record values ranging between min(col1) and max(col1), and in a ascending order I do not want to use any sort stage/inline sort feature to sort the column . How would you ever hope to output values in ascending order on the output with...