DSXchange

Thanks, Ernie. Yes, Claim and Conviction are independent children of Driver, and they are joined upstream. As I said, I am a Hierarchical stage newbie, and HJoin was on my list of the next things to try. But surely this should be achievable using Regroup? I have to observe, however that the I am fin...

Update: So I've tried that method, however when trying to map the claim and conviction children I am getting the dreaded CDIUI2820E 'The mapping is not applicable due to an invalid type conversion or difference in the source and target list dimensions.'

Back to the drawing board?

Hierarchical Regroup - Multiple children - Am I on the right track? Problem: I have a flat record coming in, representing a motor insurance quote. The quote may have multiple drivers, and each driver may have multiple claims and multiple convictions. So a tree structure with quote at the top, then d...

This is something I've been musing on for some time - there are numerous occasions where I'd like to be able to use RCP and identify key column names as parameters, for sorting, de-duping, change capture etc. The ideal solution would be a reusable component - probably a shared container - with the f...

The Modify Stage is basically a wrapper round the Modify Operator (See the Orchestrate documentation or The Datastage Advanced Parallel Developers Guide under Operators). You're limited to the conversion functions built into this operator and the type of string translation you want is not one of the...

Just came across this and thought I'd post an alternative:- If your target is Oracle, you can retrieve the column list from the metadata table all_tab_columns. It's not pretty, but here is some working code, this generates a SQL statement which is written to a file used as the SQL file in the update...

So I have a sequential file with dates in the form 2012-11-25. On the format tab of the sequential file I set the format string for dates to be %yyyy-%mm-%dd. The help text for this property is 'The string format of a date. By default, the format of the date string is %yyyy-%mm-%dd. reinforced by th...

Thank, Arnd. I'd pretty much come to the same conclusion, just wondering if there was some obscure option to switch on strong typing .....

In a transformer, fitted with a reject link, I am mapping a string to a decimal type. What I want to happen:- If the incoming data is not a numeric string, e.g. 'aaaa' I want the row to be shunted into the reject link. What actually happens (to my surprise) The value is defaulted to zero, a warning ...

Is it possible to detect if a job is multi-instance in code? I have a shared container and it generates a string based on the Job Name and Invocation ID. But when embedded in a single-instance job the call to the DSInvocationID macro throws a warning. We have a zero-tolerance policy towards warnings...

Thanks Kim. I grabbed ETLStats and had a look last night. Very nice. It gets me a long way towards where I want to go. I think using my self-imposed rules of no undocumented access to Datastage internals and 'Keep It Simple' I am going to end up with something that compromises on my 'ideal world' so...

Quick question for all ETLStats/joblogging gurus... I have been tasked with developing/upgrading a 'framework' into which production sequences/jobs can be inserted. The framework will provide various common functions, one of which is capturing job runtimes, statuses, row counts, parameters to Oracle...

Try reading the file as single column. process the records sequentially. using stage variables you can combine the transaction and addenda record. Yep. I am reading, using a sequential file stage, the whole record into a single column RECORD, type char, substringing column 1 to get the record type,...

Thanks for the suggestions - Ray - Can't you send 6 and 5 along separate links into a Funnel? Well, yes I could but (a) they have different metadata and (b) how would I guarantee sort order? Maybe I did not express the requirement sufficiently clearly - A Type 5 record may or may not be immediately ...

Well that's not gonna work is it? :roll: The CFF only permits you to interrogate a single Record Id column and send all rows of that record type down the same link. I need to send Types 5 AND 6 down the same link, and as the sequence is the only thing that connects them, to preserve the sort order. ...