DSXchange

I'll see what I can find out, see if "they" will share. Perhaps more of an issue if you upgrade an 11g instance to 12c rather than build one from scratch.

Joining to the same table 200 times won't be "pretty" either but as noted, you have to do what you have to do to get the job done. Be it source joins or lookups.

Join?

LOL... surely no one would dare. :wink: We've just completed updating all of our instances to 12c, some went just fine, others... not so much. And with Informatica, some of the workflows were unaffected while our main nightly warehouse load takes twice as long now. Not a tragedy since it went from a...

Perhaps you need something like this IBM Time Zone Update Utility for Java but I would involve support regardless.

... and if you end up needing more help with that, please start a new discussion with all the appropriate details of your particular question / issue.

Thanks.

Isn't there an option in the sequential file output to say what kind of quotes to use on string fields, including 'none'?

Out of curiosity, are you planning on using the SCD stage or "rolling your own" logic?

No clue and the person that wrote that hasn't posted here in 4 years so we may never know. Besides, I don't think it played into the solution at all, as you noted.

Just to clarify, is this an actual CDC process out of Oracle (i.e. pulling information from the logs) or this is the CDC stage in a job? Guessing the former from the way you've worded things but wanted to double-check.

Give us some context. "Executing the DS through unix" means what exactly and is this something new you are trying and has never worked? Was it working before and stopped working? Details, please.

Also, is that the full error? FYI, this topic may help.

Thanks for that.

Technically, this post should be closed as Resolved and a new one opened for your unrelated issue...

I knew we were missing a key piece of information. And you never mentioned your source was a file which would have been helpful to know. :idea: Next time either transfer your DOS files correctly to UNIX (so they drop the ^M aka x0D and /r) or simply tell DataStage to use the proper record delimiter ...

What database is this, exactly? For SQL Server, the square brackets [date] syntax should have worked or at least that's my understanding. But the rules for reserved words change from DB to DB so it would be good to know for certain which one it was. And yes, a stern finger-wagging is in order for wh...