Sorry that I didnt noticed that it is of Server forum. Compress stages i avaiable only in PX.
BTW as Kenneth suggested, beyond the thershold of 10K should be considred to directly by skiping the DS.
If compression is the only criteria looked for, some external compression can be followed.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
There's no "compression" stage. You'll have to find a compression algorithm and write it as a DS function.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
I sure hope that compression algorithm is understood by whatever looks at that column of data. Taking "jpeg" data and compressing it with an lzw algorithm means you no longer have jpeg data, but lzw. If you're expecting lzw data to show as a picture, you'll first have to un-lzw it to get it back to jpeg. This means that the compression algorithm has to be also used by any queries when getting the data.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
i had downloaded a C algorithm for image compression from the net and trying to implement it in the datastage routine, currently i did'nt get any success but i am trying to rewrite that algorithm in BASIC format.
Thanks & Regards
Parag Saundattikar
Certified for Infosphere DataStage v8.0