DSXchange

Hi, We have a problem here which started couple of days earlier. We have scheduled our jobs through Tivoli workflow Manager but lately we notice that the jobs fail to fire . We have tried to fire jobs from Director/Disigner but some times it happens that the jobs does not reponds to the run button. ...

Kumar:
Thanks a lot , its working now, I should have got this before

Mani:
Thanks for the reply...... I'll definetly search your Intec Jobs

How can I compare current record with previous record in stage variable? Can stage variable store previous record value or it is reset for every new record?

I tried searching but couldnt get to the right topic ...If any one has the link or keyword to search would be of great help.

Congrats Kumar !!
I remember all that I gain from your post, You are the first to answer to my posts most of the time.
Keep it up.

Hi, I have this situation where I need to find the gaps in the sequence and write all the gap in a file. Source is like Col1 Col2 A 1 A 3 A 4 B 2 B 5 B 7 The target would be: Col1 Col2 A 2 B 3 B 4 B 6 I have to take into account the Max and Min value in Col2 and find sequence gaps for each unique en...

My comparing criteria was only rows/secs from transformer and filter stage.

A character comparision !

Hi,
I found that using a filter stage slows the process when compared to the same condition being used in transformer stage.
We are more flexible to use condition in constarint in transformer stage than in Filter.
Then where should we use filter stage???

I'm geting this in the log file: main_program: This step has 2 datasets: ds0: {op0[8p] (parallel CDR_DATA_CUX) eAny=>eCollectAny op1[8p] (parallel APT_TransformOperatorImplV0S1_M_EXTRACT_CDR_DATA_S1_Transformer_1 in Transformer_1)} ds1: {op1[8p] (parallel APT_TransformOperatorImplV0S1_M_EXTRACT_CDR_...

In TOAD the total time taken to run the whole query is 15 mins.
Do i write in a sequential file in serverjob at /dev/null?

we are using 8 nodes in our APT CONFIG file

how do i find the number of process using APT_DUMPSCORE?

Yes , The extracted results are directly dumped into a dataset

With Toad as client I get results in 15 mins flat but with datastage its taking 1hr 30 mins approx.

Hi, I'm extracting data from Oracle database and using Oracle Enterprise stage and the db is partitioned but the problem is that the data fetching rate is very slow < 400 rows/sec. I'm using Read Method as User defined query and using columns in the where clause which is indexed. Nobody else is usin...

Hi Amar,
If you want to store your parameter values in a table a want to pass that at run time then you probably have to write a script to fetch the value from the table and pass it as parameter while firing the job through command line.

Regards
OP

And what about this.... I guess you have selected the Object type as Library. Since you have created a object file select the object as the option. I have done the following: Type:External Function Object Type: Object External subroutine name: BinaryToDecimal Return type:long Library path:/home/man...