Search results for query: *

I've often observed that Oracle's partition pruning is not very effective when a query doesn't refer to the partition key in the query. for example select d.attribute1, sum(m.measure) from dimension d, fact m where d.id = m.d_id and m.d_id = 12345; Or, select d.attribute1, sum(m.measure) from...

Hi Guys, I have a confusing problem, I wrote following program to populate a table. It gives me an "Invalid Character" error but when I generate output using dbms_output and run it is works as expected. Declare valStr varchar2(250); tmSlice date; hh24 number; mi number; hago date; minSeq...

Hi Guys, This is quiet puzzling scenario. I'm creating a table using a sql statement (create table as select...). When I compare the results from that table against the sql statement that created it I get different results. I am stumped. May be I am making some stupid mistake but I'm kinda of...

For some reason I am not able to translet the old outer join syntax to the new one. Here's my original query, SELECT count(1) FROM table0 t0, table1 t1, table2 t2 WHERE t1.col1 = t0.col1(+) AND t1.col2 = t0.col2(+) AND t1.col3 = t2.col3(+); I translated it...

What is the advantage of creating surrogate key on time dimension? Especially, if the scope of the warehouse application is confined to a limited geographic area in one time zone, like the state and local governments agencies, would it make sense to create surrogate key on time dimension? Anand

Hi, I have managed to successfully register xml schema and create the xml tables. I now need to load the data into these tables. I am now working on different scenarios of loading the XML data into these tables. I successfully experimented with the SQL/PLSQL options as well as SQL*Loader. I am...

Hi, I've posted this questions on 10g forum also. Since I saw more interaction on this one I am posting here again. If you don't discuss XML on this forum please excuse mu intrusion. I am a complete Newbie to XML. I registered the xml schema, which also created the XMLType table...

Hi, Not sure if this forun deals with XML. In not, please excuse my intrusion. I am a complete Newbie to XML. I registered the xml schema, which also created the XMLType table. (PurchaseOrder from Oracle Documentation) I alsoinserted one record into the table. I can successfully extract...

Hi folkes, I am having tough time installing MS Office on my machine. I have windows XP home edition on my Desktop. Every thing was working fine untill I decided to install symantec - norton virus and internet recently. Since then I have to deal with one or the other problem every day. My...

I am having tuff time explaining to my client to use surrogate key for the dimension tables in the warehouse. We are creating a small data mart. Fact table contains roughly 50,000 rows. Daly increment is about 500 rows. The largest dimension table has 3,000 rows. Client wants to see the natural...

Hi, Is there any way to control the programs that are launched after login. I was looking at my start menu programs and couldn't locate the these login of programs. I have a bunch of programs that start automatically whenever I start my computer. Most of it is spy ware and I sure as h##l didn't...

I have a serious problem at hand. I have a linksys wireless network at home with two computers on it. One is my home PC and the other is my office laptop. My home PC has Windows98 on it. Of let I’ve been constantly hammered by the unwanted web sites gaining access on my PC. They change my...

I have a serious problem at hand. I have a linksys wireless network at home with two computers on it. One is my home PC and the other is my office laptop. My home PC has Windows98 on it. Of let I’ve been constantly hammered by the unwanted web sites gaining access on my PC. They change my...

HI all, I have a serious problem at hand. I have a linksys wireless network at home with two computers on it. One is my home PC and the other is my office laptop. My home PC has Windows98 on it. Of let I’ve been constantly hammered by the unwanted web sites gaining access on my PC. They change...

Hi, I dont know if this is right forum for my problem. I have a laptop with built in Intel "PRO/wireless 2100 3B". Recently, I was trying to hook it up to my home network that has Linksys wireless Router. For Some reason my laptop fails to see the routher even if both the machines...

I recently came across references to Netezza. They claim to have DW solution, both H/W and S/W. They are compiting in multy-terabyes application market. I went to their site but they don't offer much in way information or white papers. Has any body heard about this company or their product...

I always had a question about who is an ideal candidate to be a data architect for a warehouse project. In my experience DBAs and/or Business Experts have been elevated to model a data warehouse. DBAs plus points: 1. Better understanding of the underlying database 2. Know a lot about...

Hi All, I am building a warehouse that has Peoplesoft as one of the sources. I am fairly new to peoplesoft. [surprise] Is there any thing specific I should know about extracting data from Peoplesoft? Is there any good book/material on peoplesoft based warehouses? I would appreciate your help...