Screen Shot of Error:
locking row for access SELECT * FROM WRK.INFA_ET2_979525041610790
Here INFA_ET2_979525041610790 is error table name and WRK is database name.
Wednesday, July 17, 2013
Query to Access Error Table when Infa Session fails while loading into Teradata target
We may get error - '2652: Operation not allowed: <Error Table> is being loaded' while you are trying to access error table in Teradata.
Screen Shot of Error:
We need to lock the table in order to access this error table and below is the query
locking row for access SELECT * FROM WRK.INFA_ET2_979525041610790
Here INFA_ET2_979525041610790 is error table name and WRK is database name.
Screen Shot of Error:
locking row for access SELECT * FROM WRK.INFA_ET2_979525041610790
Here INFA_ET2_979525041610790 is error table name and WRK is database name.
Subscribe to:
Post Comments (Atom)
Thanks for sharing such a nice article
ReplyDeleteINFORMATICA TRAINING IN BANGALORE, INFROMATICA ONLINE TRAINING, INFORMATICA, INFROMATICA DATAQUALITY TRAINING, BEST INFORMATICA TRAINING IN BANGALORE