DUPLICATE RECORDS USAGE

Tools & Utilities
Enthusiast

DUPLICATE RECORDS USAGE

Hi All,

I am confused with the usage of multiset table in real time.

what exactly i mean is 

where do we require the duplicate rows and what is the use of complete duplicate row in real time.

why we store complete duplicate records and uses of it???

In which environment the complete duplicate record is useful??

 

please make me clear with this concept with any real time scenario usage of complete duplicate records.

Thanks All.

RATHOD.

1 REPLY
Junior Contributor

Re: DUPLICATE RECORDS USAGE

Teradata implements MULTISET table because Standard SQL defines them and all other DBMSes do the same :-)

Of course nobody wants duplicate rows in a production database, but they might be useful in staging area. You load duplicate rows as-is and the cleanup/aggregate before the insert into the target table.