DSXchange

The latest Newsletter talks about some of the new features coming that the Premium members will or do have access to - above and beyond the premium posts.

You right. The other way is a little... scary.

Somewhat. Premium Membership gives you full access to the Premium Posters.

The hashed file must be opened for writing first in order to create it before it is opened for reading in the job. Accomplish this by linking a Transformer stage to the hashed lookup. Yes, just a Transformer. Create a bogus stage variable so the job will compile. Match the metadata to the hashed fil...

You are already signed up for Premium Membership, that's what you are a Charter member of.

What turns up if you put 'Failed to compile test harness' into the Search function here? More than likely, the answer to your question!

Add '$INCLUDE DSINCLUDE JOBCONTROL.H' to your routine.

What's 'not working' about it?

Are you sure your target a TIMESTAMP in Oracle and not a DATE field? If so, please post the full definition of the TIMESTAMP field which would include the precision. Also, are you sure about your source date? I've seen similar Internet/XML date formats before, which typically involves swapping the '...

DSguru2B wrote:I wouldnt mind posting an article which is not on the lines of Datastage, but give an understanding of the loads for ETL to take place with the most efficient ways.

Better to just link to it, as Ray notes.

[sigh]

Not quite right. How 'bout we let Vivek work it out from there as a learning exercise rather than pick up the spoon again?

Reread what Roy posted, more carefully this time. You haven't configured DataStage so it knows how to access Oracle on your server. You need to edit the dsenv file properly and then 'bounce' DataStage. This is documented in the DataStage Plug-in Installation and Configuration Guide documentation ins...

It's just a simple if-then-else statement in your derivation. This is not something you've had to do before? The only thing that might 'complicate' the process a little is if there may be values other than TRUE or FALSE in the field, or if it might come in various cases or if it could possibly be nu...

One job to extract and another job (or jobs) to load.

Ok... you've used a routine where? In a Routine Activity stage or somewhere else? The error implies its name has either been mispelled or you've got one routine that calls another routine and that second routine doesn't have a proper DEFFUN declaration in the first routine.