DSXchange

I'm trying to do an update to a table but the transformer that is before the Oracle Connector stage does not receive data (because a constraint in a transformer stage) so the job fails and shows the next error message: The input schema column ALL_VEH_CNT is not used and the connector is configured t...

Actually I can't read your entire post... it says something of "premium content"...



Could you send me what you wrote to my email?

sergiomho @ gmail . com

Thank you!

For example, I'm actually using: Oconv(@DATE,"D-YMD[4,2,2]"):'-':Oconv(@DATE,"MTS") Because the argument @DATE is a string field. This is the timestamp from a record, saved in a file. Reading this field as string and I want to save it in a table using milliseconds. But using Ocon...

With this conversion Oconv(@TIME,"MTS") it only shows up to the seconds of the @Time argument I want to see the .nnn ( .ff) Is there somehow to do it? I need the timestamp formatted as: yyyy-mm-dd-hh.mm.ss.nnnnnn Using the original .nnn, not .0000 (zeros are not what I need, I want to see ...

Hello Kryt0n, as I understand, this "Built-In" Transform, the "DATE" word between quotation marks is to indicate to what data type is going to be transformed/converted the supplied parameter/argument. About the single quote mark, is how the director shows the "Event detail&q...

The record in the file is: 2011-10-21 15:43:11 The file stage shows the record as: 2011-10-21 15:43:11 I use the TimeStamp transformation: Name: TIMESTAMP.TO.DATE Definition: Timestamp(%Arg1%, "DATE") Arg1 = Timestamp and this warning comes up: ..LandXfrm (Timestamp) transform error: Inval...

I extract data from a sequencial file that has 4 columns and then I insert it in a table but it doesn't have an id column,

What doesn't come to my mind is how to extract the information of the sequencial file and add one row which needs to be an id column and then insert the data in a table.