DSXchange

you can design your job this way Seq_File------->Transformer------> Seq_File In the source sequential file..take the complete record in only one field only..declare its length as the maximum possible length of a record according to your input specifications Then use Dcount function in transformer wh...

The disk location mentioned in pxresource section of configuration file , defines the location where datasets will be stored on the server

you can fire a query on database from unix box.

select category from ds_jobs where job_name='your job name'

What kind of calculations/processing are you doing in transformer stage ?

As the table you are using is huge in size,one way could be to create a look fileset first from the table, with including only the required columns and then using this lookup fileset in the lookup operation.

Regards
Ulhas

Can you put the sql query here, which you are giving in Oracle Source Stage.

Regards
Ulhas

Is your sql query working successfully on database prompt ?

Regards
Ulhas

you can usually see this information in DataStage Director

Regards
Ulhas

using MOD (divide by 2) Function on dept column in modify stage,and followed by a filter stage should solve the problem.

hi you can also get the duplicates using the 'Create Cluster Key Column' Option in Sort Stage. This option set the Cluster Key column value as 1 for first record of each group and remaining records of that group will have Cluster Key Column value as 0. Depending upon your requirement of which record...

you can achieve the desired result by using range partitioning on database table.This will ensure that data belonging to a month goes in a single partition.we have implemented in oracle,not sure if range partitioning is available in other databases create table tablename ( ID INTEGER, CREATED_DATE D...

As the last post here looks almost 1 yr old..is there any trial version of DataStage available now??

Thanks in advance

Regards
Ulhas

Remove the copy stage if it is not required and try running the job. Check if you get the same result

scratch disk is used as a temporary space while performing operations like lookup,join,sort when the data volumne is big and the internal memory is not sufficient to hold the complete data during these operations

Guys,Please correct me if i am wrong.

Regards
Ulhas

If you are using oracle database,then you can do time conversion in different time zones using new_time function

new_time( date, zone1, zone2 )