Teradata Material
Pages
(Move to ...)
Home
INFORMATICA
Fall Back,Journals and NODES
FASTLOAD
BTEQ
Teradata SQL
INDEXES
Teradata Architecture
MULTILOAD
CONTUCT US
▼
Monday, 10 March 2014
What is the difference between Global temporary tables and Volatile temporary tables?
›
Answers: Global Temporary tables (GTT) – 1. When they are created, its definition goes into Data Dictionary. 2. When materialized data goes...
Teradata performance tuning and optimization
›
Answers: 1. collecting statistics 2. Explain Statements 3. Avoid Product Joins when possible 4. select appropriate primary index to avoid s...
How do you transfer large amount of data in Teradata?
›
Answers: Transferring of large amount of data can be done using various Application Teradata Utilities which resides on the host computer ...
Explain TPUMP (Teradata Parallel Data Pump) Utility in Teradata?
›
Ans: * TPUMP allows near real time updates from Transactional Systems into the Data Warehouse. * It can perform Insert, Update and Delete ...
Can you recover the password of a user in Teradata?
›
Answers: No, you can’t recover the password of a user in Teradata. Passwords are stored in this data dictionary table (DBC.DBASE) using a o...
What is Reconfiguration Utility in Teradata and What it is used for?
›
Answers: * When we feed Primary Index value to Hashing Algorithm then it gives us Row Hash(32 bit number) value which is used to make entri...
What is the difference between Access Logging and Query Logging in Teradata?
›
Ans: 1. Access Logging is concerned with security (i.e. who’s is doing what). In access logging you ask the database to log who’s doing wha...
What is FILLER command in Teradata?
›
Ans: While running Fastload or Multiload if you don’t want to load a particular field from the datafile to the target table then use the FI...
What are TPUMP Utility Limitations?
›
Answers: Following are the limitations of Teradata TPUMP Utility: * Use of SELECT statement is not allowed. * Concatenation of Data Files i...
What are the MultiLoad Utility limitations?
›
Ans: MultiLoad is a very powerful utility; it has following limitations: * MultiLoad Utility doesn’t support SELECT statement. * Concatenat...
What are the functions of a Teradata DBA?
›
Ans: Following are the different functions which a DBA can perform: 1. User Management – Creation and managing Users, Databases, Roles, Pro...
1 comment:
What are the 5 phases in a MultiLoad Utility?
›
Answers: * Preliminary Phase – Basic Setup * DML Phase – Get DML steps down on AMPs * Acquisition Phase – Send the input data to the AMPs a...
How to eliminate Product Joins in a Teradata SQL query?
›
Ans: 1. Ensure statistics are collected on join columns and this is especially important if the columns you are joining on are not unique....
How does Hashing happens in Teradata?
›
Ans: * Hashing is the mechanism through which data is distributed and retrieved to/from AMPs. * Primary Index (PI) value of a row is the i...
Friday, 7 March 2014
How to skip the header row in the fastload script?
›
RECORD 2; /* this skips first record in the source file */ DEFINE ...
How to identify PPI columns?
›
Answer: Select databasename , tablename , columnposition ,columnname from dbc.indices where indextype ='Q' order by 1 ,2,3 ;
What are the scenarios in which Full Table Scans occurs?
›
1. The where clause in SELECT statement does not use either primary index or secondary index 2. SQL Statement which uses a partial value (l...
How do you create materialized view in Teradata?
›
There is no such thing as a "materialized view" in Teradata. The equivalent in Teradata would be a join index (or aggregate index...
How to find average sal with out using avg function?
›
How to find average sal with out using avg function? Answer Without using "avg" we can find the avg salary by using sum (sal)/...
How to handle nulls in Teradata & How many columns can be there in a table???
›
How to handle nulls in Teradata & How many columns can be there in a table??? Answer 1. Use zeroifnull, nullifzero in select and N...
‹
›
Home
View web version