Isn't the whole point of a reference table that it's IDs are unique, so that you...

Can the 10.2 client connect to 11g?

This blog post might give an idea:

Calculating the size of your Lookup cache

Shouldn't it be the other way around? Sales is the input data and Contact is the reference table?

Where are the child packages stored, in MSDB or on the filesystem?

This is the culprit:

Which Oracle client are you using?

Maybe you can ask this question in an Oracle forum, as it's clearly an Oracle issue...

Easy one for Monday morning! Thanks.

Lynn Pettis (8/10/2012)

---

Okay. Just let off a little rant to Mr. Celko again. Please, if anyone thinks I went too far (and no, you'll have to find it...

GSquared (8/10/2012)

---

jasona.work (8/10/2012)

---

Wi nøt trei a høliday in Sweden this yer?

See the løveli lakes

The wonderful telephøne system

And mani interesting furry animals

Including the majestic møøse

A Møøse once bit my sister...

Don't worry, that's what he does.

Most people just ignore him and go...

So why exactly is price incorrect? 15 + 20 + 15 = 50.

If you want the average value, you need to calculate it yourself (unfortunately there isn't a built-in function)....

Right, in Belgium we use dd/mm/yyyy. My mistake...

In your sample data there isn't any data for ABC in Oktober 2011. Yet your results show there is. Did you link the dimensions properly to the fact table?

Because it isn't. Probably a minor bug in the syntax checker.

Let's say you have two net changes: row A is updated and row B is inserted, in that order.

You retrieve those changes with the CDC source and you use the...