DSXchange

Sorry
Smalll correction

I want to append the zeros for the ColA. And It should be equal to the ColB' zeros.

thanks

Thanks for all,

And Can I append the zeros for the same problem which was disscussed above instead of removing the zeros?
If there is any function plz let me know.

thnaks in advance

Hi, I have data like ColA(Hash) ColB(Src) 2577 , 0002577 13 , 0000013 345 , 0000345 I need to match these col's and based on this condition I need to populate other fields into the target. Here both col values r same but colB is having some zeros preceding the value. How can I eliminate the zeros? N...

Hi Balaji Did you try working on your doubt no 2? If so Did you find out the reason as to how it allowed you to remove duplicates even though the dataset is not sorted? I saw the source file, its not in sorted form. But the job producing proper output. I don't know what is the reason? any assistance...

Hi Ray, This is my Configuration file which contains 2 nodes. { node "node2" { fastname "PROXY-1" pools "DefPool" resource disk "C:/Ascential/DataStage/Datasets" { pools "" "pool1" } resource scratchdisk "C:/Ascential/DataStage/Scratch...

Hi Balaji,

Thanks for your advice.

This may improve performance and also save temporary space.

How will it save the Temporary memory?
Could u explain indetail plz?

Thanks in advance

Hi, Thanks for ur advice. I got the solution for it. But One more doubt I have. i.e Here I am giving the 4 cases: 1) I have used Seqfile--->RemDupStage--->Peek In this case I have processed the data without sorting it. Though its giving the expected results. 2) I used Internal Sort(Perform Sort) n p...

Hi, I am Using Rem Dup stage to remove duplicates n using Inter Sort for sorting the date. Whe use the Internal sort(Perform sort) its giving some warning msg as given below. Rem_Dups: When checking operator: User inserted sort "Rem_Dups.To_RemDup_Sort" does not fulfill the sort requiremen...

Hi , When I define 2 nodes in Same Partition the Job is getting aborted n with single node its working fine. The error log I got is main_program: Fatal Error: There are irreconcilable constraints on the number of partitions of an operator: parallel Sur_Key_For_Same_Partition. The number of partition...

Hi Balaji,

What u said I didn't understand. U said to configure the peek stage to output all records from all partitions right, how to do it? can u suggest me?

thanks in advance

Hi Kumar, What u said is right. when I give Round Robin its giving same no. of records in the output. But in the Round Robin the out put is varrying like below. I am providing the log results here. When I select 2 nodes in SK Gen Stage n 1 node in Peek stage the Results I am getting in a single Peek...

Hi, I am running a job with stages like seqfile--->SurKeyGen--->Peek with 1 lakh records. When I define 1 node in a 'Node Map Constraint' its giving 1 lakh records as output but when I define 2 nodes its giving the 2 lakh records as output. My partitioning type is Entire. Why its giving double of th...

Hi Ray,

Thanks for ur reply. But how can I get the reply for my doubt?

thnaks

Hi, I am using the Remove duplicate stage to eliminate the duplicates. In the properties of Rem Dup Stage there is one Option called "Duplicate To Retain" . It has two values like First or Last. I want to capture the Duplicate data. How can I achieve this? Any answer is appreciated. thanks...

Hi,

How should I contact the Vendor or Datastage regarding some doubts which r not solved in Dsxchange Forum? And give their mail id plz.

Any help can be appreciated.
thanks in advance
RK