DSXchange

ray.wurlod wrote:So you have a number of blocking columns (which must match absolutely) and no matching columns. Is this right? ...

**

I have 7 columns:=LAST_NAME, FIRST_NAME, MIDDLE_NAME, GENDER
BIRTH_DATE, PHONE_NO, ADDRESS.

Please advise me,

Hi All, I am using Unduplicate Match to find matched, dups and non matched records. I gave 7 columns in MatchSpecification at Blocking Section, i didnt touch the Match Columns section. Now - when i ran the job which has 15 records its fine, some(5) are matched and some are dups(8) and some are nonma...

For my knowledge, i realized that Version 8.0 behaves a little different. Try doing a force compile for that job from designer, provided you are sure that you are the one who locked the job. ** when i open that job, it is saying it got locked and do you want to open a read only job. But i didnt see...

For my knowledge, i realized that Version 8.0 behaves a little different. Try doing a force compile for that job from designer, provided you are sure that you are the one who locked the job. ** when i open that job, it is saying it got locked and do you want to open a read only job. But i didnt see...

Hi,

I was working on one job, after sometime it was saying that it got locked by the specific user. That is my user only, how to unlock that job.

I dont have admin privileges.

Please advise,

DateFromDaysSince(180,DSLink1.CHANGE_DATE) Hi, I tried with the below function: DateFromDaysSince(180, DSLink1.CHANGE_DATE) it doesnt give any error but where i have 1 record in input transformer passed 0 records to output. if i didn't use this function i am getting 1 record into output. please adv...

Yes, that's the function and it happens to be the first one documented in Appendix B of the Parallel Job Developer's Guide. Pass it a date and a # of days offset. Hi, I was trying with this function, couldn't able to use it. Can you please give me an idea how to use it to add 180 days. my input col...

Hi,

I have a date column in source table, I am using 8.0 Parallel - i want to add 180 days to the source date.

I think the function is DateFromDaysSince

Please advise me how to use it for my requirement.

Thanks,

Hi All, I have a table, i want to find matching records, dups, and nonmatching records within the table. I have used standardize and match frequency, then i have used standardize out and match frequency to Unduplicate Match Stage. I have to use match specification for Unduplicate Match Stage, in new...

Disable operator combination so you can discover which stage is throwing the error. You are running out of scratch space, and there is at least one short record in your input data. This can be disce ... -- How to clean this scratch space, what does mean a short recor in input data - what to do with...

Hi, I am using standardize and match frequency stages. i can able to run standardize job successfull same as below input1=> standardize1 => stanout1 input2=> standardize2 => stanout2 then i have used stand outs for match frequncy same as below stanout1 => match_frequency4 => matchfreq1 stanout2 => m...

Hi, I have a question about standardize stage - I have two different tables, i took the two standardize stages to standardize the data. input1->standardize1->output1 input2->standardize2->output2 when i opened a new process in standardize, i have 10 available columns. But i need to use 5 columns to ...

Dear All, I am using 8.0 and very new to qualitystage... I have two input tables, i have to match those table with 5 columns[firstname, lastname, dob, Gender, phoneno]. I can able to view the data in both input tables - please let me know how to standardise these 5 columns and how to use matchfreque...

Dear All, I am using 8.0 and very new to qualitystage... I have two input tables, i have to match those table with 5 columns[firstname, lastname, dob, Gender, phoneno]. I can able to view the data in both input tables - please let me know how to standardise these 5 columns and how to use matchfreque...

Dear All, I am using 8.0 and very new to qualitystage... I have two input tables, i have to match those table with 5 columns[firstname, lastname, dob, Gender, phoneno]. I can able to view the data in both input tables - please let me know how to standardise these 5 columns and how to use matchfreque...