DSXchange

The simple solution as been shared. If you are not comfortable, you can aslo have another DS stage with user defined query as "SELECT #PARAMETER# from DUAL"; and pass this value to the consecutive DB stage.

That variable will be passed as an Parameter to the next job. You can make you of the parameter in transformer stage or even in you DB stage to write in to table.

Check in your DS Adminstrator setting for environmental varialbe TEMP_DIR, if it is pointing to this directry, it is used as scratch space.
Else check your Config file, you can find if it is been used as one of the resource pool.

Lookup will be always efficient when the lookup data can be made to fit into memory. Try to increase the scratch space else try out some other strategy like converting lookup into join.

dslearner wrote:

kumar_s wrote:I dont get the logic how you mapped "x y z" and "ddd eee ttt" to "ColA ColB ColC" .
Shouldnt it be "A B C" and "AAA BBB CCC" ?

These values are different.

How do you select "AA BB CC" and "x y z" (By what logic)?

That might be your temp directory. The Scratch will get used during run time. Are you using lookup fileset or sparse lookup?
You may need to increase the disk space for the directory.

Yup. Got it. :D

Shouldnt be the CLEAR.FILE for RT_LOG** working?
Any how RT_STATUS wont contribue much in space.

Or go to DS Director, to that category, print the "Current Category" to a File. Tweak the output with an text edition.

... without damaging the control records.

Ray - Are you refering to RT_LOG*** file?

You need to decide the partiton based on your requirement. If you need to a grouping function like, aggregation(count of records)... you have to follow the grouping partition (hash) else you can proceed with what has been suggested.
For grouping in your case you can even go for sequential mode

Do you have dataset in the temp directory? Check with "orchadmin describe {dataset}" command to know the details about the dataset. If it has single data file and that too lies in the same directory, you can delete it. Else check the extension first, and later use "rm" or "orchadmin rm" accordingly.

The BASIC Transformer stage in parallel jobs uses the BASIC run machine that used in Server jobs. Hence it need to be loaded when the parallel job is executed.
But it gives you richness of the function set in BASIC.
Do a search on "Basic Transformer",you ll find numerous post.

yakiku - Amazing!!
I guess we need to check any other VB application, with the presence of the file 'Program' under the C:\, whether it works normally. Might be a problem with MicroSoft.

I dont get the logic how you mapped "x y z" and "ddd eee ttt" to "ColA ColB ColC" .
Shouldnt it be "A B C" and "AAA BBB CCC" ?