DSXchange

I have one source field: Address_Line = 5353 Windward Pkwy so I would like to split this into two fields: House number = 5353 and Street = Windward Pkwy so do we have any function in DataStage to achieve this.

Thanks
Jana

Hi I would like to extract the house number and Street from Address field so I am wondering how to do it in DataStage.

Thanks
Jana

Hi, I have the source column: Total_Life in Months and I would like to translate to Number of Years field and Remaining Months field. Ex: Total_Life = 40 Months Number of Years= 40/12=3.34 out of this I want only 3 (yrs) Remaining Months=.34*12=4 Months approximately. Basically I need to avoid decim...

Hi, I see a built-in transform CAPITALS is available under Transform/Built-In/String that converts a string to word-initial capitals. but how I do use CAPITALS built-in transform that convert the first letter of each to uppercase and remaining string to lower case. I am unable to drag and drop this ...

Hi, I see a built-in transform CAPITALS is available under Transform/Built-In/String that converts a string to word-initial capitals. but how I do use CAPITALS built-in transform that convert the first letter of each to uppercase and remaining string to lower case. I am unable to drag and drop this ...

Hi Ray, I performed below two steps to resolve this issue: a. Standardize Job for Source DataSet and Reference Dataset: In match frequency stage included all fields. b. In he Match Designer: Specify that there are not frequency data available for the field using Variable Special Handling with NOFREQ...

Hi Ray,
Thanks for help and it worked perfectly.

Jan

ray.wurlod wrote:Find the stage in which an explicit collection algorithm has been specified and change it to (Auto). ...

Thanks Ray,
Yes I did investigation and Standardization process.

Thanks
Jan

ray.wurlod wrote:Have you done investigation and standardization on these data? ...

Hi, When I am running QualityStage Match process job, I am getting the below fatal error: main_program: Fatal Error: An operator with concurrent inputs cannot change the collectionMethod for a virtual data set if this method is defined and not equal to eCollectAny. could you give me any resolution o...

Hi Julio, I successfully resolved the issue and I am able to see all the match test results but when I ran the job, I am getting the below fatal error: main_program: Fatal Error: An operator with concurrent inputs cannot change the collectionMethod for a virtual data set if this method is defined an...

Hi do you guys have any Idea why I am getting the above error. Basically I have one source standardised dataset, one source frequency dataset, one Verispan standardised Dataset and Verispan Freq ds for referencr match process. I am getting the below two errors while testing match passes: 1. ##I IIS-...

Hi do you guys have any Idea why I am getting the above error. Basically I have one source standardised dataset, one source frequency dataset, one Verispan standardised Dataset and Verispan Freq ds for referencr match process. I am getting the below two errors while testing match passes: 1. ##I IIS-...

Hi Vasu, I am also getting the same error and see below the log. Did you find any resolution? I dont see that column in Frequncy file as I see only 4 columns: qsFreqValue, qsFreqCounts, qsFreqColumnID, and qsFreqHeaderFlag so I dont see the column: _qsC_StateAbbreviation_USAREA in frequency file. Pl...

Hi, I am getting the similar error while testing the match passes: Please help me on this issue. Thanks Jana ##I IIS-DSEE-TUTL-00031 09:38:41(001) <main_program> The open files limit is 2000; raising to 2147483647. ##I IIS-DSEE-TOSH-00002 09:38:41(002) <main_program> orchgeneral: loaded ##I IIS-DSEE...

Hi, I am getting the similar error while testing the match passes: Please help me on this issue. Thanks Jana ##I IIS-DSEE-TUTL-00031 09:38:41(001) <main_program> The open files limit is 2000; raising to 2147483647. ##I IIS-DSEE-TOSH-00002 09:38:41(002) <main_program> orchgeneral: loaded ##I IIS-DSEE...