DSXchange

Thanks for your reply Aruna and ray .

Hi guys, i done column analysis for table location. if i delete a datasource contain table location from my project. will info analyzer clear all analysis information for that particular table in IADB database? Is there any other way to clear the analysis information. Regards

Hi, Am new to information analyzer and i had lot of question. Am doing column analysis on flat file size of 2.3GB. It had 6.6 million rows. What is the amount of space needed for this table in DB2? am using 2 proc of 3.6GHZ ,160 GB harddisk and 3GB Ram..how long it will take to finish column analysi...

Hi kiren, first do undup match on file A. you will get fileA match and residual records. assign unique ID for each matchset and assignseperate unqiue id for all residuals. now confrom the fileA match and residual and put in one file. do geomatch from fileA to fileb as one to multiple match[Dont know...

Match Frequency stage generates frequency data that tells you how often a particular value appears in a particular column. example: In the name column "john" appears more than 50 times and another value "johan" appears 2 times.if you matching on name and address. In matching proc...

Dependent pass will use residual and master records from previous pass.

Regards

Hi, you have to give output from standardization process as the input to match frequency. atleast the input columns of match frequency must be same like standardization output columns. sometimes mismatch of metadata may cause this error. Check out the job for the metadata... i hope this will solve y...

thats great joyce...

could you Make this thread as resolved...

vairamuthu

Hi,

yes , you will have same amount of output records as in your pass statistics.

regards

hi, you have to create a subroutine .Sorry i forgot to mention make post_process call as last subroutine call in pattern action file after unhandled_modification make it like below CALL Post_Process EXIT ;It will end the whole process.so you should make as last call then you can place your subroutin...

Hi , If your business accepts the john,jon,johnathan are same then in the classfication table give identical output value to all 3 firstname . I.E. john john F jon john F johnathan john F now standardize and match. you can bring all 3 names in one matchset. Regards Vairamuthu Hi All I am trying to u...

Hi arvind, Match frequency give you information on how often a particular data appear and its format. Example : you have customer_name column having data "john" for 150 times. Output give you the number of occurrence of john and statistical value in single row. So your output may be smalle...

Hi whelbi, When you try to setup the test environment from your laptop ,You will only get the Local DSN from your laptop. you will not get the DSN created in server. you have to create a ODBC in your laptop which points to the database in server. OR Save the match specification and passes and Contin...

Yes you can do! Create a new field in dictionary file I.E. FullAddress C 100 S merging_all_address_fields in the pattern file... inside the Post_process subroutine make this rule as the first one.Dont add return command at the end [ {HN} != "" | {HS} != ""] ; if any value populat...

Thanks ray for your reply...

i found the problem. i added the registration filed in blocking and i added in critical missing ok.

now took out the registration field from blocking and i got the expected output..

Regards
vairus