DSXchange

Hi, How will the Round Robin method in Link Partitioner stage work? I loaded 12 records from src to tgt using 3 XFM stage b/w Link Partitioner n Link collector stages. Src is Seq file n Tgt is DB2. when i load the data it distributed 2 records to 1st XFM and 4 reocs to 2nd XFM and 6 recos to 3rd XFM...

Hi Rasi, thanks for reply . there is no need to sort the data. Just I am splitting the data into 3 transformer stages and collecting into one db2 table using Link Collector. I want to improve performance. What is the performance overhead using Hashing algorithm? thanks Kumar . I am using 2 Transform...

Hi, I am doing some performance tunning in one job. For that I am using Link Partitioner stage for partitioning the data. In this if I use Round Robin algorithm its running fine. But when i use Hash algorithm and in the link collector stage using Sort/Merge, job is running long time. What could be t...

Hi, I would like to know how many processors will be in a Single CPU SMP system and 2 CPU SMP system? Is there any constraint to use only these many processors should be used in SMP systems? Could anybody give some brief description about these? Any assistance would be greatly appreciated. thanks in...

Hi Balaji, I will give a simple scenario here. I am loading two columns into Hashed file from DB2. one is Key col. suppose the data is like key col1 col2 10 x 10 y 10 z when I load the data into hashed file i will get only the last record i.e 10, z but i want the value x to be loaded into my hashed ...

thanks Balaji,

But if i want to take the first record what should I do?

thanks in advance.

Hi,

I am loading the data from db2 to Hashed file. I have a key column in Hashed file. suppose if the key column is having 5 same values which value out of 5 will store in the hashed file either first or second.....fifth?

thanks in advance.

Hi Chulett,

Short answers are: 1) concatenate. 2) Intelligent job control or a 'file watch' process that kicks off the job and passes in the found filename.

Could you please give some brief description about your above message?

thanks in advance.

Hi Ray,

I am sorry , that i am not able to read your message fully. What to do to get the full message. Someone inthis post mentioned that to read that message we should get membership.
Could you give some details about it please?

thanks in advance.

Hi kaps,

thats just an example I was describing...I can't create a table for every field which need to be cleansed.

You need not create any table individually. Just you have to create 3 hashed files and map them with source file in the Transformer Stage.

Hi, Situation is You have more than one file exactly the same format but different file names. How should we process the diff cases below. case1. All files come at the same time case2. File comes at different times so how should we process as and when the file arrives any response can be appreciated.

Hi parag.s.27, You can simply use the DateGenericDateDiff transform function. Can u just explain how to do with this function please? As i read in the Server guide this function gives no. of days between two dates. If u get this again we need to take care of Leap Year also know(please correct me if ...

Hi Sunshine,

Thanks its working fine.

Thank you all for your immediate response.

Hi Chulett, thanks, and from the days I want to calculate No. of years and No. of months. Ex: D1 is 2006-01-23 and D2 is 2004-10-15 then the result should be 1.3 yrs. How should I proceed for that? Any idea please? ArndW I am not able to read your message fully. How to get the full message? thanks i...

Hi, Y=Field(Oconv(D1, "D-YMD[4,2,2]"),'-',1)-Field(Oconv(D2, "D-YMD[4,2,2]"),'-',1) Mon=Field(Oconv(D1, "D-YMD[4,2,2]"),'-',2)-Field(Oconv(D2, "D-YMD[4,2,2]"),'-',2) If Substrings(Mon,1,1)='-' Then M=12-Field(Mon,'-',2) End If Substrings(Mon,1,1)<>'-' Then M=M...