DSXchange

As suggested define the parameters in the job properties and use API stages to read from the table and write into a file.

It seems you are getting a control file for the data file. if you have less info like data file name, record count and arrival time then i would suggest to do the data validation by using unix script. Also you need to check for the size of the data file. if it is huge or in GB you can create a temp ...

This would be much easier wit sequencer. If you don't want to use seq then tell us how u r getting the parameters.....

Other wise you can have a wraper script and give the parameters decideing on the parameters let it call the required job.

Hey i think you are not clear with the requirment. If you want to do some kind of funny tricks then dont post this kind of queries......

After splitting the sentence in to columns try to validate each column one by one with the reference data....

Then use tranformer to get the sentence from the columns...you know how to do this

cheers....

Use the sql in your database stage....
select sal from employee where sal>avg(sal)

And link the out put to a flat file which is having same meta data as the table...

cheers

I have faced this issue before.. it has noting to do with indexing.....try the options in view or tool bar.....
i cant exactly remember which tab exactly helped me to view the job tree

I think you have installed corrupted version......try to get latest version and install it properly.

Yes you can do that.....But you should use intermediate files or tables for streaming stages

For this join can be the best option.
beacause in look up you can only get records of master dataset,

HI, I am getting the following error while running the job main_program: Incomplete read of header from descriptor file /work/DAR/data_wrk/a.ds: expected 56, got 5 main_program: Error reading ORCHESTRATE File Dataset descriptor for '/work/DAR/data_wrk/a.ds'. /work/DAR/data_wrk/a.ds: Data set initia...

I have few records like this 11, A,B,C 11,A,B,C 10,A,B,C 10,A,B,C 9,A,B,C suppose the first column is ID. i need all the records which has the maximum id for the combination of 2nd,3rd and 4th column. My output should be 11,A,B,C 11,A,B,C how do it do it? Please help. Its urgent If 2nd,3rd,4th colu...