DSXchange

Something akin to that... for you, perhaps.

Being synonymous, does it really matter?

Hmmm... I honestly don't see how having any kind of a "long" or complex constraint would cause a job to hang as you are seeing. I'm thinking there must be something else going on but not really sure what. Have you tried setting the constraint to something simple like @TRUE or @FALSE to see...

So, resolved?

And the pipe delimiter? I'm not sure off the top of my head why you'd be seeing the behaviour you are describing unless the delimiter was set to a comma in the stage.

Why not just talk to your co-worker?

So... when you say "in one line" you actually mean "in one column", yes? And are you certain you set the delimiter to a pipe in the stage? I'd also be curious what the data type of this column is...

It depends on your email server. Try various delimiters - space, comma no space, comma space, semi-colon... one of them should work.

So... this is resolved?

Of course and that would be true of any table. The obvious solution is to correct your job so it doesn't log extraneous message, especially millions of them.

You should either look them (the errors mentioned) up or take them to your DBA.

Thank you... figured as much but wanted to confirm.

No, there is no equivalent to Informatica's "Target Load Plan".

when i implement the following oracle function in DS Transformer level i am getting the following error message. Sorry but why would you think you could use an Oracle function in a Transformer? Look up the equivalent DataStage function and use that. Or are you saying you are attempting to do that?

I'm curious... do you need the data transformed from columns to rows? If so, that would be a horizontal pivot something that (worst case) you could do downstream of the CFF stage if needed.