Archives of the TeradataForum
Message Posted: Fri, 13 May 2011 @ 20:15:03 GMT
| 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;-)
JK
| 
