Archives of the TeradataForum
Message Posted: Mon, 23 Jul 2012 @ 10:25:28 GMT
I am facing teradata error 3149 while executing a Join query between three table (one fact, one dimension and one source). source and fact table contains 2285183 rows and 63 columns.
Error is : 3149: TDWM Filter violation for Query Request: For Rule Name 'Unrestrained PJ - Max Row Count'
Query is :
Select a.cloumn1, b.column1, b.Id, c.Id From DB1.SrcTable a Join DB2.Dimtable b On a.cloumn1 = b.column1 Join DB2.FactTable c b.Id <> c.Id
Can anyone help me to understand the reason of the error ?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|