Mar 14
Question 1: Difference between MultiLoad and TPump? Answer: Tpump provides an alternative to MultiLoad for low volume batch maintenance of large databases under control of a Teradata system. Tpump updates information in real time, acquiring every bit of a data from the client system with low processor utilization. It does this through a continuous feed …
Mar 09
Question 1: What is the fallback or no fallback option while creating table DDL? Answer: FALLBACK requests that a second copy of the each rows inserted into the table has a duplicate copy in another AMP in the same cluster. This way we can make the copy of the data inserted into tables. While NO …
Feb 26
Question 1: Explain TPUMP (Teradata Parallel Data Pump) Utility in Teradata? Answer: TPUMP allows near real time updates from Transactional Systems into the Data Warehouse.It can perform Insert, Update and Delete operations or a combination from the same source. It can be used as an alternative to MLOAD for low volume batch maintenance of large …
