DSXchange

Why go to all this trouble (and double the disk space needed) when the stage supports automatically reading multiple files with a wildcard pattern? is there any limit for concatenating the data for a single text file? On Windows? Disk space. if file extension is same and file format different(like d...

No, just more verbose.

Can't answer your Informatica comparison question, but it sounds like they are similar. Searching the forum turns up quite a number of hits - perhaps this one is a good place for you to start. I'm not really sure what you mean by "i have one doubt that hash file will use Hashed algorithem for gettin...

No, not a smaller array size - smaller transactions. Meaning commit more often during processing. When Transaction Size is set to zero, you only commit once when the job ends, something that requires the most amount of undo tablespace but makes restarting easy. Setting the Transaction Size to, say 1...

Of course! My assumption was that your Server job was landing the data to a flat file and that your PX job loaded from that file into the target database. That's how I would handle it.

You already had your rejected row in the log. One of the values on that row should have been the culprit. Something to keep in mind - setting the Array Size to something larger than 1 can make it report the wrong row (or rows) in situations like this. Setting it back to 1 and running the job one mor...

And you have it set to Oracle right now, I assume. How about my Key column statement? Have you marked any columns as 'keys' in the stage? And do you really want to run this complex query, which has no ties to the incoming row so it gets the exact same result each time, for every row that passes thro...

Interesting. It was for me. Did you reboot after removing them?

I'll check a couple more machines today.

I finally tried what Ray adviced, and it worked! The job finished in under 5 minutes. I have one problem though. This cache size is set at the project level. What impact will it have? Cause when i tested this job, there was nothing else running taking the cache. Impact? The only 'problem' with this...

Welcome Aboard. :D If all you want to do is 'link' the two jobs, as in first run one and then the second on completion - that's what a Sequencer job is for. At its simplest, you create a new Sequencer job and add two link Job Activity stages. Fill out the properties of each so the correct job is run...

What are you expecting to happen here? There is no extra whitespace showing in either your Arg1 or Ans, so it looks just fine. If posting it changed what you entered, try reposting it using the Code tags above so it will preserve the spaces - and Preview before actually sending to make sure it's ok....

Well, I guess Akhil will let us know.

Still got the issue of no bind variables to deal with.

Sure it does. Can you post an example of the string you are trying to trim, your syntax and what result you get please?

If you don't specify a character to trim, by default it will do exactly what you want - leading, trailing and multiple occurances in-string of both spaces and tabs.

Hmm... that just controls the behaviour of the parameter markers in a reference link and if they must start at :1 or not. Don't really think it will fix this problem, but it couldn't hurt to try it and see.