Viewing 15 posts - 6,541 through 6,555 (of 11,678 total)
Smash125 (8/13/2012)
No then you will have unique rows for each look up id or Contactid
Isn't the whole point of a reference table that it's IDs are unique, so that you...
August 13, 2012 at 2:04 pm
Can the 10.2 client connect to 11g?
August 13, 2012 at 1:59 pm
This blog post might give an idea:
August 13, 2012 at 12:56 am
Shouldn't it be the other way around? Sales is the input data and Contact is the reference table?
August 13, 2012 at 12:50 am
Where are the child packages stored, in MSDB or on the filesystem?
August 13, 2012 at 12:44 am
This is the culprit:
TNS:could not resolve the connect identifier specified
Which Oracle client are you using?
Maybe you can ask this question in an Oracle forum, as it's clearly an Oracle issue...
August 13, 2012 at 12:43 am
Lynn Pettis (8/10/2012)
August 10, 2012 at 2:24 pm
GSquared (8/10/2012)
jasona.work (8/10/2012)
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...
August 10, 2012 at 2:23 pm
sqlfriends (8/10/2012)
CELKO talked aobut DDL of my post, but here I only ask the question about the extra comma,
Don't worry, that's what he does.
Most people just ignore him and go...
August 10, 2012 at 2:19 pm
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)....
August 10, 2012 at 5:29 am
suresh.muppidi (8/10/2012)
Dimensions and Facts are properly related. here date field was in 'MM/DD/YYYY' format.Thsnks,
Suresh.
Right, in Belgium we use dd/mm/yyyy. My mistake...
August 10, 2012 at 5:24 am
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?
August 10, 2012 at 5:05 am
deepzzzz (8/10/2012)
Why it is not an error?
Because it isn't. Probably a minor bug in the syntax checker.
August 10, 2012 at 4:59 am
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...
August 10, 2012 at 12:19 am
Viewing 15 posts - 6,541 through 6,555 (of 11,678 total)