DSXchange

If it is fixed to field F1, F2 and F3 then you can use transformer to acheive this. Add two links for each field check. Add constraints to each link. For first link check If F1=1, Then do the required transformation in the derivation part. In the second link check for same F1=1 and do the other set ...

Or do a lookup to the table2 for a dummy column with a value say '1'. You can check the lookup condition as give by you table1.a>table2.b and table1.a<=table2.c.

You can still use this code with small modificaiton. vRunningTotal = 0 --> InitialDeclaration. vCorrectFlag => If Type = '08' Then if Amount = vRunningTotal Then "Correct" Else False Else '' vRunningTotal =>IF Type='06' THEN RunningTotal+Value ELSE 0 You havnt mentioned what to do after ch...

Assuming the data is as shown in your post, you will have to separate the data based on the ',' delimiter before implementing the solutions suggested by Arnd and Guru. Rebuild the string, putting the ',' back in after the manipulation. Rob It is assumed, Amarpreet has given the values for single fi...

Arnd - The sample shows the increase in elapse time of Runtime. Shouldnt it get shorter.
arun@sinmax - If you have large volume of data to run, pls do it and produce the result, which will be optimal to analyze.

Also depends on the database conectivity, it is costly to fetch value for each record, it is considrable to have no sparse lookup. Database available in tele network will be an example.

Syllabus is available in the same IBM website. Or do a search.

Here we find a person who might use 'dssearch' if it was available in his version.

For a lengthier record, sometime it may not be effecient to increate the number of reader per node.

Infact you can change to size based monitoring.

You cannot the way you specified, by you can try to promote the job to the a level up, and equal to the forth comming sub job controler. Hence based on the result of Job (Jobactivity) you can trigger the rest of the stages which inturn controlled by a master job controller.

I usually convert data into julian date which returns a inteegr, and makes easy to play around with it.

Just happend to see now...
SQL is a language to query database. Aggregator is a stage which help to acheive just the group by function available in SQL. Not sure what is your exact doubt?

If you reference oracle stage directly, it doesnt create any fileset, (hope you are not talking about virtual dataset). Search for Sparse lookup data will get looked up directly from the database.

The same as been discussed here. But I belive there is a patch already released by IBM for passing string across aggregator stage. Search for more information in this forum.