DSXchange

I've done plenty of 'before sql' alter sessions in the OCI stage, but not that one specifically. You are correct that the trailing semi-colon isn't needed unless multiple statements are involved, but I don't recall them causing runtime problems if included. Easy enough to check by removing it. Did ...

I am saving a TIMESTAMP into a TIMESTAMP WITH TIME ZONE column in an Oracle stage. However, I want to A) Store it in a different time zone than the default. B) Preserve the Time Zone when extracting the data and moving to other Oracle databases. Does anyone have suggestions? Here is what I've been a...

No luck with the -.001000 idea. The best I've come up with this cumbersome idea. The first part deals with even seconds and the second parses out the subsecond portion and performs arithmetic on it and then appends it back together. Yuk. If(Field(FunneledData.TRANSACTION_TIME,".",2,1) = &q...

I need to subtract one millisecond from a Timestamp in a Transform stage. However, TimestampFromSecondsSince is apparently only partially-compatible with subsecond times. For example, this derivation: TimestampFromSecondsSince(-.001, FunneledData.TRANSACTION_TIME) yields this result: Input :2007-04-...

I have a similar need but I need to subtract one millisecond from a timestamp. However, TimestampFromSecondsSince is apparently only partially-compatible with subsecond times. For example, this derivation: TimestampFromSecondsSince(-.001, FunneledData.TRANSACTION_TIME) yields this result: Input :200...