Posted by rperetz on 09/01/06 22:16

Hi all,
I was given a task to create a houseHolding logic under a table that
have millions records.
first let me explain what is a house holding:

let's say I have 2 records that have the same phone number, that mean
that both records are under the same household, but this can get more
complicated
this article explain it
http://www.teradata.com/t/page/115924/index.html

if anyone worked with household he knows that you need to scan the
table many time to get all the house holds, I used a dts to do it.

I tested the dts on 11 records like the article did and that work
great, but once I went to million records each loop is taking me 2 hour
or so....a and I have no idea how how many loops I will have to do.

if anyone out there worked with household queries and used sql, your
imput would help me allot

thanks.

• Next in forum: Does SQLMail require a mail account on the Exchange Server?
• Prev in forum: Re: Text Column question
• Thread view: DTS that does HouseHolding with Millions of records

[Reply to this message]