Archives of the TeradataForum

Message Posted: Thu, 06 Sep 2012 @ 19:30:46 GMT

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

Hi,

Create a lookup table with "username, source_system "

add a column for the source_system and filter to the view definition.

     ... where source_system in ( select source_system where user = username );

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