DSXchange

ArndW has already pointed in the right direction.

Also did you bounce your datastage instance after changes to dsenv ?

PS : I am assuming that you are running in Solaris box.

Which folder(s)?

There are few security links which may not be copied.

Craig,

The difference is the inclusion of parameter and stage names to provide precise set of actions.

Kamal - Maybe couple of screen shots may answer.

1.) Sequencer
2.) Job properties from sequencer
3.) Job properties from job

You need to have one pre-job job which will populate the hashed files. Changes to this job will be then a simple replacement of ODBC by hashed files and providing its properties. If by "not using key" you mean "not using the key defined in the database", using hashed files will h...

You should write a loop in a job sequence to expand that wildcard and call the routine within the loop. ... Arul, can you help me to write this loop ? Where did Arul come from? You need an executeCommand stage to get list of files in the pattern. Also loop stages to control the flow. Try it and ask...

Kamal, Try the following steps Open the sequencer -> Double click on the job stage to open its properties -> Ensure you are on 'Job' tab -> Click on k_ftch parameter to get your mouse focus -> Click on the elipse (...) to enable editing of parameter -> Click on the elipse again to get list of stages...

What is the current performance? i.e. rows / second, CPU consumption, I/O usage etc. This will give you an idea of what you can optimize. Can you provide the job design so others can comment. Some of the points you can look into in the code supplied are 1.) Avoid OConv on both sides of the compariso...

It will be very useful to provide actual names of the parameters than talking relative reference names - x and y. 1.) What is the job name? 2.) What is the parameter in the job called as (not the job sequence) ? 3.) What is the name of the executeCommand stage in your sequence ? If you answer the ab...

Does the user with which you are connecting to Oracle via DataStage have select priviledges on the sequence ?

What are the transformation rules?

Is the same field being 'reused' to derive 2 output fields or will the one input field be split into two halves ?

What is your design? i.e. source, target, machine spec, volume etc etc.

What activity is consuming most time and resource ?

Without any information it is not possible for others to respond.

You were on hold for 30 mins and you posted expecting a response.

Please be patient as others have their regular work and posting is done when they get time.

As you are doing a line count, I guess this must be an integer.

Set final delimiter to none and record delimiter to unix newline.

From the looks, it appears to be an issue with your record delimiter in file1.

What is the value set for the property ?

In the sequencer
-> Open job properties
-> go to the parameter (x)
-> set the value as the one mentioned