Search results for query: *

I don't have any experience in this but a couple of things come to mind. The split can mean two things, 1. Horizontal split, i.e. split the data while keeping the formats and standards for Metadata and Master Data. 2. Vertical split, i.e. functionality split where one of the spin off gets a...

following approach worked fine in our case. a. All transactions are recorded in GMT (UTC) b. Create separate "Time" dimension with a grain oh hour, with a grain based on UTC. c. Add time zones to "Date" dimension with separate zonal columns for each time zone- One column to store "time...

I would create product_group_dim table and then conform it to the product dimension. Anand

Oh, and I forgot to add that in the scenario that i describe the fact table is partitioned on d_id. Anand

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...

mayidunk, I don't have the book handy with me so my answer is going to be a little vague but have you considered creating a single dimension table with all the pertinent attributes for both the account types? If they are mutually exclusive then those would simply be null. As you know, null...

Concur with SantaMufasa. The syntax is correct. Anand

How do you clone the database? If it's a copy of a cold backup then you can set the profile in the source database. Anand

Check the number of concurrent processes allowed on the server. I don't know if or how you check it on Windows server but on UNIX it's a setable kernal parameter. Anand

This error means type specified by the using clause doesn't exist. Can you share your DDL statement with us? Anand

Silly me. That was it!! Removing the semicolon solved the problem. Thanks, SantaMufasa!! Anand

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...

Dagon, They all belong to same schema. The MVs were created this morning right before creating the staging table. I droped the thable and recreated again as queried it immediately. Same results!! Now, here's fun part! I created the view like you suggested and I get yet another set of results...

Dagon, yes there are differences but the question is why? Since I am creating the staging table using same query. Anand

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...

John man, you have solved so many of our problems that if you had charged 100 bucks for every solution you would be millionaire by now. :) here's a purple star from me. Anand

Is this table in Oracle database? If so, then can you post the error message? Also, The column name "[check]" is not in Oracle compatible format. Anand

That's a great tip. Does it work on different versions of client software? I mean what if I have 8i,9i and 10g clients? Anand

sweetleaf, just curious. Do you intend to create a copy of the dimension table for each data mart and the original remains in the staging area? If yes, what what is the reason behind it? Anand

Try this. I made a few changes to your code because I personally prefer to use functions whenever there is a return value. I haven't had a chance to test the package myself. May be, the resident experts will have better solution for you CREATE OR REPLACE PACKAGE GroupsPackage AS TYPE...