DSXchange

Hi,

Thanks for all your help, i am now trying to write a routine with compression algo, that compresses the image.

Thanks for quick help

ArndW wrote:Binary image data is usually already very well compressed. A normal compression algorithm will never achieve 20-30% on image data (assuming a common format such as .bmp, .gif, .jpeg). You might be abl ...

Hi Arnd,

Sorry but i am not able to see your reply.

Ok, but what kind of transformation do you expect DS to be able to do with this image data? If you are only passing it through unchanged then DS will have no problem with that amount of data as long a ... Hi, Actually i was looking for some compression kind of stage as mentioned by Kumar_S. If its ...

Explain the data, what kind of information you expect to change in it. ETL tools are about text and number manipulation. Binary data manipulation requires you to understand the binary nature of the attribute and how to manipulate it. Hi, The data is actually in some binary code with each of atleast...

I am fairly certain that the transform stage will not be able to transform the image data. How can it? You haven't specified what sort of modifications you want to do. DS can read and write binary da ... Thanks again, Then can i compress it earlier before feeding it to the transformer stage, as men...

Don't pass binary image, audio, or video data thru any ETL tool. Moving large amounts of binary data on each row thru each active stage is a staggering misuse of memory. Moving text and numbers is n ... Hi, Actually the images are not that big and secondly the data is of Customer Masters so not hav...

kumar_s wrote:Any stages used in datastage doesnt reduces any used in it.
But you can use compress stage initially to compress the files if required.

Thanks for quick help Kumar,

But i am not able to find compress stage in my version. the version is 7.5.1.A, can you please help me again.

thanks

But Binary/Varbinary/LongVarBinary could be used. But i don't know whether Transformer stage can simply read image data and transform it or not. So if i use these Binary/Varbinary/LongVarBinary data types then can i transform the image to reduce its size to a certain limit. and what impact wii ther...

Hi, I am having a source file in which i am getting images. Can i migrate the image data from source to target. i need to transform it to reduce its size. so i wanted to know. is it possible, if yes then what data type shall i use for it in the meta data, because i never found any oracle like BLOB ...

Alas, the environment variable changed value is not inherited by the parent process (the job's controlling job sequence), so that approach fails. So does the approach using system variables, for a si ... Hi Ray, I was not able to see the entire content of your reply probably because you are a premi...

Does it have to be an environment variable? Can you use a system variable (such as @USER0), or the job's user status area? ... Hi Ray, Actually i was not sure whether a system variable value is accessible across multiple jobs in a sequence. But i thought that if i can set environment variable then ...

From your post, i guess your requirment would be to set a envirnment variable to particual job or to a series of job based on a conditon. If that is a case, you can use 'UserVariableActivity'. Built for the same reason. Hi Kumar, I am already using UserVariableActivity. But for that i need to prede...

I tried to do it by passing Stage Variable value directly to a User Defined Environment variable but it did'nt work. What did you try? Or how did you try? Please let us know. If I remember correctly, you can call a environment variable in your stages like this way: #$ENV_VARIABLE# Thanks, Naveen. H...

Hi, I have a situation where i need to use environment variable value in a sequence of jobs. I wanted to know that, is there any way in which i can set the environment variable value in any stage for example in Transformer. I tried to do it by passing Stage Variable value directly to a User Defined...

Hi All, I am running a sequence for my 5 jobs. To all these jobs i provide the input parameters from a USER VARIABLE stage. Now in this stage i also give the target file name. Now i want that data in a particular column in the source file must come as a part of my target file name. can i dynamicall...