|
View previous topic :: View next topic
|
| Author |
Message |
kalyan_lc5
New User
Joined: 06 Jul 2006
Posts: 9
|
|
|
|
There are two flat input files present in the program. The program is about comparison of keys of both the files. The requirement is both the files can have duplicate key values. How do I go ahead with the comparison of keys if the scenario is N:N ?
Kindly give us the solution to implement N:N logic?
Kalyan |
|
| Back to top |
|
 |
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA
|
|
|
|
| Quote: |
| Kindly give us the solution to implement N:N logic? |
Unless you are willing to pay the going rates (and 1000 U.S. dollars per day is not uncommon), please do not ask for code. People who respond here are paid for their professional work product, which is what you want when you ask for code.
Besides, this is a HELP forum, not a DO-YOUR-JOB-FOR-YOU forum. What have you coded so far? |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
Before "slinging code" there must be a clear definition of how the many-to-many must be handled. If there are 10 repititions of key "A" in file1 and 13 repititions of key "A" in file2, what should happen?
How is it decided which 3 are "not matched"? Are they all considered to be a match? Some other rule?
Until the rules are defined, code should not be attempted. . . |
|
| Back to top |
|
|
Terry Heinze
JCL Moderator
Joined: 14 Jul 2008
Posts: 1249
Location: Richfield, MN, USA
|
|
|
|
| What is "N:N"? |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
| I guess a typo for M:N logic |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
I suspect it is for many-to-many. . . Instead of 1:N or N:1, ta daa N:N. . . |
|
| Back to top |
|
|
|
|
