Life at a telco, early this century

This happened a long time ago…

Boss’ Boss: Hey Simon. IT are testing a system. Can you give them a million call records from the finance copy? They want realistic test data.

Lowly Little Me: Er… OK. Don’t they have access already?

BB: Well, you know. It’s about being helpful.

LLM: Ah politics. Not interested. Ok anyway…. is this for that monthly reporting thing?

BB: Yes.

LLM: So, you need records distributed arbitrarily through time? Not just the last million calls?

BB: Yes. And include texts too. Everything really.

LLM: OK

Alt-Tab -> TOAD. New file.

select * from (
select caller_number, count(*)
from
	normalized_event ne
group by
	caller_numer
order
	count(*) desc
)
) where rownum < 1000

Hmm… these add up to about a million…. click… click… click…

Huh, how come there are so many calls for these top numbers? .. peek … ah… porn lines! Wow! I guess that’s realistic. Maybe I’ll throw in some from further down the list.
click… click…

select * from
	normalized_event ne 
where 
	caller_number in ( .. pasted list .. )
 and rownum < 1000000

… wait…

Export to CSV…

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s