Forum Replies Created

Viewing 15 posts - 406 through 420 (of 3,061 total)

  • RE: Design Strategy

    krishnavamshi24 (3/25/2012)

    Thanks for the reply,Yes i understand truncate and insert would be simple way to do this but i want to minimize the number of inserts / deletes by rather...

    March 26, 2012 at 7:40 am

    #1464250

  • RE: Data WareHouse

    codebyo (3/25/2012)

    I'd really love to hear someone's opinions on why the Oracle community is somewhat difficult to find. Very different from the SQL Server community which has important events like...

    March 26, 2012 at 7:35 am

    #1464245

  • RE: Data WareHouse

    Farnaz Safaee Nik (3/25/2012)

    My mean is that i want to set up data warehouse. i want to set up data ware house in sql or oracle.now,my data are store...

    March 25, 2012 at 3:25 pm

    #1464045

  • RE: Surrogate Keys Dimension Tables

    Welsh Corgi (3/24/2012)

    I just need a clear and concise quick argument as to what they have done is wrong.

    Surrogate Keys add a level of abstraction that isolates and protects the...

    March 25, 2012 at 1:01 pm

    #1464030

  • RE: Surrogate Key vs Natural Key DImension Tables Dimensional Model

    Welsh Corgi (3/24/2012)

    Could someone please help me explain to a nontechnical person why it is bad practice to use the Natural Keys from the source systems as the Primary key...

    March 25, 2012 at 12:49 pm

    #1464025

  • RE: conersion of sql server code to slq plus

    murarka.ankita2007 (3/25/2012)

    please convert below code of sql server to sql plusso that it doesnt generate syntax error.

    Please don't take this the wrong way but this is so wrong it is...

    March 25, 2012 at 12:38 pm

    #1464024

  • RE: Design Strategy

    krishnavamshi24 (3/25/2012)

    I Have a query on data migration, now i have a two tables (A & A1) where A is parent table and A1 is child table. This is setup...

    March 25, 2012 at 12:27 pm

    #1464020

  • RE: Separate Staging Tables and Data Warehouse into different Databases.

    Welsh Corgi (3/23/2012)I'm concerned about the time it takes to back up the Database and recover it.

    By definition Staging tables should be truncated and loaded on each ETL cycle...

    March 24, 2012 at 7:12 pm

    #1463960

  • RE: Separate Staging Tables and Data Warehouse into different Databases.

    Welsh Corgi (3/23/2012)The design does not even come close to a Star Schema or Star Snowflake Schema.

    Nothing that indicates a Fact Table or Dimensional table, just a repeat of the...

    March 24, 2012 at 7:08 pm

    #1463959

  • RE: Separate Staging Tables and Data Warehouse into different Databases.

    Welsh Corgi (3/23/2012)

    PaulB-TheOneAndOnly (3/23/2012)

    Welsh Corgi (3/23/2012)

    Until today I never saw a Database that contained both the Staging Tables and Data Warehouse Tables in the same Database.

    This is common practice in...

    March 23, 2012 at 3:19 pm

    #1463829

  • RE: Primary key

    Lynn Pettis (3/23/2012)

    GilaMonster (3/23/2012)

    sandeep4testing (3/23/2012)

    FK- FName should be FK of Users.FName

    FK- LName should be FK of Users.LName

    Names as foreign keys? That's a weird design.

    Even weirder is that from the looks...

    March 23, 2012 at 1:40 pm

    #1463758

  • RE: Separate Staging Tables and Data Warehouse into different Databases.

    Welsh Corgi (3/23/2012)

    Until today I never saw a Database that contained both the Staging Tables and Data Warehouse Tables in the same Database.

    This is common practice in "some" RDBMS other...

    March 23, 2012 at 1:24 pm

    #1463746

  • RE: not getting rid of physical reads

    Confusing Queries (3/23/2012)

    We did not have proper indexes on production and almost all the queries were using clustered index scan having high physical reads.

    Now we have created new indexes specially...

    March 23, 2012 at 1:18 pm

    #1463738

  • RE: Primary key

    Lynn Pettis (3/23/2012)Here is the other problem, your table can have only ONE primary key.

    Yup... just a basic, tiny, tiny, small like this (shows finger tips real close) detail, init?...

    March 23, 2012 at 1:15 pm

    #1463734

  • RE: Modeling Design / Approach

    gyoung,

    There is something we call best practices which basically means we do stuff in certain ways that have proven over time to be the most efficient ones in terms of...

    March 23, 2012 at 1:06 pm

    #1463714

Viewing 15 posts - 406 through 420 (of 3,061 total)