![]() Related Questions How many types errors will be occur in total SPOOL process and How can we connect a database server from to other server(i.e., i have to connect another server from a present server) View Question | Asked by : zaheer Teradata will redirect the new inserted row as per its PI to the target AMP (on the basis of its row hash value), and if it find same row hash value in that AMP (hash synonyms) then it start comparing Latest Answer : When the target table has UPI then the Row hash of PI column will lead to the AMP and the duplicate row is rejected with an error.In case of a NUPI defined on a SET table the duplicate row is compared on all columns and if the entire row is dups ... Global Temporary tables (GTT) -1. When they are created, its definition goes into Data Dictionary.2. When materialized data goes in temp space.3. thats why, data is active upto the session ends, and definition Latest Answer : In addition to the Shilpa's answer,If you are using volatile table,you can not put the default values on column level ( while creating table ) ... How many error tables are there in fload and what are their significance/use?Can we see the data of error tables?How many error tables are their in mload and what is there use?When mload job fails, can Latest Answer : Ideally, there are 2 error tables in Fload. These table contains the details about the data parcel from source to the target table. We can view the data in error table.It has below detailsErrorCode, ErrorFieldName, and DataParcel ... How many types errors will be occur in total SPOOL process How will you connect a database server to other server? Latest Answer : We can connect from one server to another server in UNIX using the commandssh or FTP or SUssh -Â ssh user_id@server_name ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||