DSXchange

These functions are pretty swift. Before you can blink, it would process thousands of records and add 6 hours to it. Did you run a benchmark test for this. Just throw in a row generator, pass it through a transformer and add 6 hours to the current time. Test it out for your max anticipated number of...

Now, use the same data partitioning strategy in the job that references the hashed file. You use N instances of the same referencing job with the expression in a constraint to limit the rows processed by that instance (prior to the hashed reference of course). Ken, a follow up question. How exactly...

ray.wurlod wrote:What a wonderfully useful Subject! (Not)

I see a Borat in you

Do a search in the pdf file.
The short example to pass parameters is

Apply Trim() function on the keys. Because 'ABC' <> 'ABC '.
ANother possiblity might be that you are doing a group by operation, is there any chance of transforming a column that is being used as a key in the hashed file? If any single key is different, the lookup will fail.

Pass your data through aggregator, group by FirstName, LastName and Street. Provide anything for ID, and provide MAX() for all the rest of the columns. Anything will be greater than a space or empty byte or even a null.

Make sure your keys are trimmed, both for the source and lookup.

I am afraid there is no other way. If you want to keep checking your job and incrementally add stages, you can always let your output stream go to a copy stage. It can consume all the rows without complaining.

You can use stage variables to hold previous rows values and do your manipulation there. Search the forum on the 'How to' part. Search on keywords like row comparison.

Ok, your going in circles and confusing us. Plain and simple: -Create a stored proc. and call it in the before sql tab. OR -Create a script and call it in the before job subroutine using ExecSH . If you search in google on how to execute a script to access oracle tables, you will get so many results.

Read the Server Job Developer Guide, specifically Command Line Interface. It will give you the exact syntax.

Actually, the question should have been, Where the heck did ftp come in from? This entire thread is to get a pl/sql code working from within datastage. I mentioned a 'here script' and referenced Ray's post where he explains a 'here script' using an ftp example. According to me, thats all that ftp re...

Can you run sqlplus from your datastage server? You should be able to. Run a sqlplus command and excute your query.

But the job sequence wont be restartable from point B, will it? as its successor job (Job C) will run.

Do you have this jobs log open in any director? Go to 'Cleanup Resources' under Job button in the director and see if you have any sort of log on any RT_LOG file.