DSXchange

Welcome. First let's get you in the proper forum. There, all done. Now, there's no need to do this in two transformers or even two steps unless you need to store the intermediate string value... do you? Otherwise you just 'inline' the two function calls, put the first inside the second. To help with...

ray.wurlod wrote:

rkashyap wrote:What is the source of the ComponentValue and BusinessRule file?
How big is the ComponentValue file?
Which flavor of Unix are you using?

Why do any of those matter?

Probably because there's some awk coming.

Sure, lots of people I'll bet. Doesn't anyone where you work 'speak UNIX' that could help you? Nothing about that is really all that specific to DataStage.

You don't "convert" it so much as replace it with NULL and that should just be an if-the-else derivation or something similar.

As noted by Ernie, build a version of your job that drops your generated XML to a file rather than directly to the web service. Then you can see what, if anything, is wrong with it. The link I posted should give you an idea where to start looking at least.

One doesn't exist until a much later release, I'm afraid. Depending on your C++ coding chops you can look here for the PX version of the Server EReplace function, which an exact search for "PXEReplace" should turn up I do believe.

Resolve the deadlock. If you're not sure what that means, enlist your Oracle DBA. They may be able to trace the execution of the job from the database side and give you some clues. Typically it is caused by running your job on multiple nodes with improper partitioning. If you are running on more tha...

No worries about the rules. Yet.

So this is actually for a Parallel job and not a Server job type as posted?

One example of several that an exact match search for "substring matches" turned up.

Perhaps?

http://illegalargumentexception.blogspo ... rolog.html

Perhaps that's a hint that you should.

Well... where does the starting year come from - the system date? Something in the file or filename? Seems to me if you have the starting year then you just increment it by one for each subsequent row. Of course, I could be greatly simplifying the process. :wink: Perhaps if you posted some specifics...

This is all captured, stored and can be reported on by the Operations Console from what I understand.

True... way back when I was shocked to see it work just fine with loops, something I wasn't expecting.

'In a new group', meaning has the value of ID changed. You can do it all manually via properly sequenced stage variables or you can leverage the Sort stage (even telling it to not sort) with the Key Change column property enabled. It will add a new column to the stream that when true means the first...