DSXchange

Re: FAQ entry - PM sent.

Right. Those options were made for other purposes and when used as you noted, there are... limitations.

Your metadata doesn't match your file's data, nothing more than that. What settings are you using in the stage? What is different between a row it will process and one it rejects? Can you post an example of each?

Did your DBA explain why that happened? When you join two columns of different data types, Oracle 'up converts' one to the other data type under the covers. In your case the string field was converted to a NUMBER before being joined to the incoming data and the moment that conversion happened it cou...

I'd check with your official support provider, see if this is a known issue.

Correct, it's not really meant to be used for the purpose you attempted and if you want to 'insert thousands of rows' you should source from a file of values and let the 'main flow of data' handle all that. I've used it to dynamically build SQL for the stage to read so we could customize the select ...

I can't say for certain but typically zipped 'sub-folders' or objects like that should be left alone, the installer will handle those for you.

StringToDate() followed by WeekdayFromDate() should do the trick.

From what I recall, you assign values to the parameters using the ISD tool as well. (in the past, via the RTI console)

I'm curious why the "need" for the dsx file format? In the 8.x world and going forward, istool is the mechanism for imports and exports.

Once for each node if the stage is running in parallel mode.

Let this be a lesson to you and anyone playing along from our home audience - always give us proper (as in real) examples, not made up, half-assed bogus ones!

From what I recall, you have to 'edit row' (by double-clicking on it?) in order to find those properties. Then you select 'Packed' and then the proper 'sub-property' to let it know how it is packed. It's all in the documentation.

pandeesh wrote:Moderator,

Is it possible to change the topic name to sum using Transformer?

Yes, and you can do it. You can edit any of your own posts, including the topic starter, so have at it.

The example given isn't quite packed/zoned decimal notation (the values for the sign are not correct), therefore the overpunch sign option won't work which is unfortunate. I wasn't going by the example (we've seen plenty of bogus / misleading / incomplete examples in the past) but rather by the des...