Viewing 15 posts - 481 through 495 (of 3,061 total)
I agree with Johan - what calls my attention is not that second statement fails (which is expected) but that third statement shouldn't work and apparently it does work.
February 19, 2012 at 8:53 am
Rowles (2/18/2012)
What percentage of SSIS packages that are used are for data warehousing?Are SSIS packages used frequently with third party applications?
1- It all depends, if a given organization has no...
February 18, 2012 at 4:53 pm
ColdCoffee (2/17/2012)
PaulB-TheOneAndOnly (2/17/2012)
What tool would you use to screw togheter two pieces of wood? a hammer or a screwdriver?
Both the tools bond 2 pieces of wood.
I would ask...
February 17, 2012 at 4:08 pm
Loundy (2/17/2012)
February 17, 2012 at 2:48 pm
GSquared (2/17/2012)
PaulB-TheOneAndOnly (2/17/2012)
Jeff Moden (2/11/2012)
PaulB-TheOneAndOnly (2/11/2012)
Just loading a table hardly qualifies as ETL.
Seriously? You don't think that taking a mega-row text file from something like Double-Click.Net and loading it...
February 17, 2012 at 2:01 pm
If you want to get rid of the data use truncate.
If you want to get rid of the object use drop.
What tool would you use to screw togheter two...
February 17, 2012 at 1:56 pm
Jeff Moden (2/11/2012)
PaulB-TheOneAndOnly (2/11/2012)
Just loading a table hardly qualifies as ETL.
Seriously? You don't think that taking a mega-row text file from something like Double-Click.Net and loading it into a...
February 17, 2012 at 11:10 am
sqlvogel (2/16/2012)
we use "star (schema) design", which is a synomym for "dimensional design" for Kimballistic Data Warehouse databases and we use "relational design" for OLTP databases.
That's seriously inaccurate. The star...
February 17, 2012 at 10:51 am
...as an alternative:
SELECT OWNER, TABLE_NAME, COLUMN_NAME, DATA_TYPE, DATA_LENGTH, DATA_PRECISION, DECODE(NULLABLE, 'Y', 'NULL', 'NOT NULL')
FROM dba_tab_columns
WHERE OWNER = '???' --<< Plug Schema Name Here
ORDER BY OWNER, TABLE_NAME, COLUMN_ID
;
February 17, 2012 at 10:40 am
sqlvogel (2/14/2012)
PaulB-TheOneAndOnly (2/14/2012)
star schemas are not relational, they are dimensional.
Maybe you don't really mean that Paul? Star schema is a design pattern quite commonly seen in relational database design. "Dimensional"...
February 16, 2012 at 10:40 am
nick.mcdermaid (1/23/2012)
... relational star schema
star schemas are not relational, they are dimensional.
February 14, 2012 at 9:33 am
Jo Pattyn (2/13/2012)
Somewhere on this forum there is a link to various Oracle-forums
You can try http://www.dbasupport.com/forums/forumdisplay.php?f=20
February 13, 2012 at 11:20 am
rocky_498 (2/12/2012)
I am very new in Oracle. I would like to know is there any way i can create a Backup of Oracle Db and Restore it Like SQL has?
Either...
February 12, 2012 at 1:06 pm
Jeff Moden (2/11/2012)
PaulB-TheOneAndOnly (2/11/2012)
...ETL is a concept, a methodology that describes how to transport data from OLTP systems into a Data Warehouse database.
Gosh... it's a whole lot more than that....
February 12, 2012 at 11:20 am
Rowles (2/10/2012)
February 11, 2012 at 2:54 pm
Viewing 15 posts - 481 through 495 (of 3,061 total)