Archives of the TeradataForum

Message Posted: Thu, 22 Oct 2009 @ 14:58:22 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Consider the case in our project

We have to store the calling no, called no, duration, later we will be taking aggregate of that number's sum (duration)

If a person calls to 1 number more than 1 time and total duration is also same then we have to capture both the rows to get the exact called duration from that mobile number

In this case we will store the total data received from source as it is (multiset ) and will filter out as per the requirement

Regards

Rahul

	<Prev	Next>		<<First	<Prev	Next>	Last>>