Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 13 May 2011 @ 20:15:03 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Use case statement to select the desired table
From:   John_Wight

Anomy.Anom wrote:

  I need to access the "patient" table that may resides in different schema depending on the region I need to pull the information from.  

It sounds like you have a basic architecture issue - i.e. You broke up your data into different tables based on region instead of putting it all in one entity! A lot like putting history data in different tables by year!!! Something I would not do, but that's just me.

I would put all the data in one table and qualify with your Region ID/Code - or what ever! Just a thought;-)


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023