DSXchange

If you absolutely have to use the hashed files, then you can use a server job which is not advisable unless the job is small. The other way is to build a lookup file set just the way you built the hashed file. You can also load the contents of the hashed file into a sequential file in a server job ...

Hi
I have hash files in my server jobs as those files were used as lookups, I need to access hash files for lookups in parallel but parallel ext doesn't support hash files. So, do I need to convert hash files to different format to access them in parallel and how ?

I really appreciate your quick replies.
As I am new to parallel jobs ,I may have asked some silly questions. But the main point is that I wanted to know

What important points or strategy should I keep in mind while redesiging a server job into parallel?

thanks
nitin

Hi Ray, Thanks for the prompt reply. I have some more doubts, if you could help me out 1) The target hash file created in server job , how would I use that file in parallel ? 2) As you mentioned Link collector shouldn't be used , what about funnel or merge stage are they similar to link collector? c...

Hi! I need to know if the job is designed in server and has to be converted into parallel job. What consideration should be kept in mind will redesigning the job in parallel such as 1)what should be used to replace hash files in parallel? 2)How to implement pipline and parition parallelism ? what cr...

How to turn spread sheet (xls) into a delimited flat-file ? you can save the file as csv ( coma delimited) or tab delimited or unicode text. Thanks for the promt reply. See I am new to datastage , I have been told to convert spred sheet file to delimited flat file using datastge. What i did is save...

How to turn spread sheet (xls) into a delimited flat-file ?

Thanks for ur time n help...problem solved

shepli wrote: If you want to get all the numbers from a table starting with number 201, you may want to use something like this:
input.ClmName[1, 3] = 201

ArndW wrote:If you cannot put this condition into your source SQL reading from the table, you can add a constraint in a transform stage with a condition like In.MyColumnName => 201 ...

:D

I have a question , I want to use condition in transformer stage such that i could get the result of all the numbers from a table starting with number 201 ( in sql we use like statement what is the substitute for it in datastage in server jobs)

Thanks