[quote1262909407=skd_mrk]
[quote1262901301=Leroy]
Hey buddy, I've built a couple of data warehouses, I'm currently designing ETL and CDC processes in my current company. Fun stuff.
Welcome aboard.
[/quote1262901301]
What's your platform? I'm currently working primarily on an Oracle platform with some DB2 exposure. Pharmaceuticals and sales mostly at this point. ETL, some DBA functions (partitioning etc), and minor Business Objects tasks on the Oracle warehouse. The DB2 stuff is all handled through Ab Initio.
Hailey, you can call me Jon. Just you though.
[/quote1262909407]
Oracle 10g, with a future phase planned to 11g (not much should change though)
Small world, I work for a med-large sized insurance broker up here in chilly Canada, and my last project dealt primarily with pharmaceuticals, particularly the active ingredients contained in each. A ton of data is being generated that our number #1 client (the gov't) needs to report on for years to come, so obvious the best way to facilitate this requirement is in flat storage, or OLAP.
I have zero experience in big, bad DB2. I've heard of Ab Initio, but I'm already moving around a million rows in ~6 seconds on DEV databases, so we don't really need Ab Initio... yet... I have a healthy understanding of optimizing the data medium, so this is good enough for us. The nice thing is Oracle manages the CDC nicely, no need to extend upon that, but cleaning the data in the ETL process has resulted in a fair amount of headscratches as we have to resolve personal data (Are these two people the same person?)
Good times.
And, uh.. my name is John as well.
I'm not entirely convinced we're not the same person.
