DSXchange

Schedule it... unless you enjoy manual labor, that is.

Nothing is enabled or disabled based on the installation of the RTI Console. Pretty sure the same can be said for the RTI Server component. Sure, things won't work without it but you should be able to 'RTI Service Enable' a job and add the stages to one without it installed and working. Just don't t...

They are the output of a core dump when a program aborts / abends. Sometimes a vendor will be able to examine one to figure out what went wrong, but typically they just are just messy little piles of information that need to be cleaned up. It is not atypical for a cron job to exist that runs periodi...

ray.wurlod wrote:Had the OP wanted to use Oconv(), the second argument would be "MCN"

a.k.a. the DIGITS transform.

Welcome aboard. First suggestion would be to try searching the forum here as most problems have been solved several times here already. Searching for 'date conversion' as you used for your subject turned up a number of posts that would help you out, including for example this one. Or specifically se...

Hmmm... typically, an issue around the 2GB Barrier would actually corrupt the hashed file and give you fun things like 'blink' errors. This is more indicative of either a space problem or something funky in the data you are writing. It can also depend on if you received just this single error or man...

Let's approach this the other way 'round. what does is the difference between link.notfound and not(isnull(lookuptable.columnname)) Back in the old days, checking for a null value was the only way to see if a lookup had failed. You fill out the key value(s) from the input stream and the lookup 'fire...

Ray's got another way having the Loop step through a delimited list of dates. Don't see why the way I outlined wouldn't work as well, the decider would be how you needed to use the parameter, if you had a chance to switch it back to 'external' format within the job or if you needed to use it before ...

I concur... but please don't call me Shirley.

We've now got six replies to the original post (seven if you count Ray's double) all guessing what ssunda's actual problem is. Rather than having any more well intentioned people pile on with their entry into the contest, here's a thought... Why not wait for the OP to come back and clear things up? ...

Actually, for the OCI stage with a Timestamp datetype, the format you 'need' is: 1972-11-11 11:35:34 (yyyy-mm-dd hh24:mm:ss) Assuming you are letting the stage generate the sql, your job's metadata for that field is Timestamp and your target field in the Oracle table is a DATE as you've stat...

Its runs good, but i know this isnt a right approach and this wont solve my problem.I want to pass the date not as numeric but in its original format say YYYY-MM-DD or MM-DD-YYYY. You can't - not if you want the Loop stages to control the iterations. You'd have to roll your own, I would think, if y...

chrisjones wrote:Please let us know what to do and whom to contact immidately to solve the problem and make ETL as effectiect tool.

As noted, contact your support provider - either IBM/Ascential Support directly or whomever performs that for you. Make them aware it is "very very urgent".

Indeed.

Because, as I noted, you are telling it to replace all commas in the string with yet another comma, so it just looks like it works fine. Check the examples in the online help. It's certainly not a fatal problem, just wastes cycles. It's not all that different from telling it to replace all 'X' char...