How to Assign key Values for duplicated records
Posted: Mon Jun 08, 2009 10:36 am
HI,
here i have millions of records in my source data with duplicate records.
i need to assign key values for all records, same key values for duplicate recods.
One ID for ONE name , no matter of address
it should be done in one job.
could you let me know how it is possible.
her is the source data
Name; Address; zip
John 123 west st,VA 23233
steve 122 E st , CA 92804
John 89 NE st,NC 55123
steve 44 main st,MN 45123
John 66 old st,WI 53186
above is my source data,
i need to convert into below file. in one job.
ID Name; Address; zip
1001 John 123 west st,VA 23233
2002 steve 122 E st , CA 92804
1001 John 89 NE st,NC 55123
2002 steve 44 main st,MN 45123
1001 John 66 old st,WI 53186
John sould have 1001 ID for all addresses
Steve should have 2002 ID for all addresses.
Thanks
Vemi
here i have millions of records in my source data with duplicate records.
i need to assign key values for all records, same key values for duplicate recods.
One ID for ONE name , no matter of address
it should be done in one job.
could you let me know how it is possible.
her is the source data
Name; Address; zip
John 123 west st,VA 23233
steve 122 E st , CA 92804
John 89 NE st,NC 55123
steve 44 main st,MN 45123
John 66 old st,WI 53186
above is my source data,
i need to convert into below file. in one job.
ID Name; Address; zip
1001 John 123 west st,VA 23233
2002 steve 122 E st , CA 92804
1001 John 89 NE st,NC 55123
2002 steve 44 main st,MN 45123
1001 John 66 old st,WI 53186
John sould have 1001 ID for all addresses
Steve should have 2002 ID for all addresses.
Thanks
Vemi