Home
Contact
About
Navigation
Home
Interview Questions
Tutorials
Video Tutorials
Home
»
Teradata Interview Questions
»
How many AMPs involved in case of Primary Index?
How many AMPs involved in case of Primary Index?
in
Teradata Interview Questions
- on 03:12 -
No comments
How many AMPs involved in case of Primary Index?
Its always one AMP.
Tweet
Post a Comment
Newer Post
Older Post
Home
Categories
Teradata Interview Questions
Recent Comments
Popular Posts
What can be done to release fload locks?
1. Finish the fastload, which means leave your hands off of the error tables and restart fastload. When it finishes the table lock will be ...
What is the difference between Multiload and Fastload interms of Performance?
If you want to load, empty table then you use the fastload, so it will very useful than the multiload..because fastload performs the loading...
What is the difference between start schma and Fsldm?
FSLDM --> Financial Services Logical Data Model (Teradata FS-LDM 7.0) its developed by Teradata for the financial sectors (Speciafially f...
how do you handle ET and UV errors in MLOAD (ET = Error table)?
In mload ET and UV tables, source sequence of the error records in the input file would be present. Use that number and delete/correct the...
Explain the various load utilities in Teradata.
Teradata TPump: It is a highly parallel utility designed to continuously move data from data sources into Teradata tables without locking...
How would you execute the BTEQ?
Consider a BTEQ script contains the following code in it. .logon tpid/user, pass; /* Login credentials */ SEL * FROM tab_a; /* Que...
Teradata Realtime Scenario Question
There is a scenario like the load should start after a particular table fetches a value else it should Bteq session should exit there is...
What is error table? What is the use of log table?
The Error Table contains information concerning: - Data conversion errors Constraint violations and other error conditions: * Contains r...
Teradata Scenario - interview question
A scenario like ,there is a BTEQ where it has delete statement followed by an insert and update.Suppose the delete statement has been execut...
What is identity column in TD?
In Teradata the identity column is the one, where the value gets inserted automatically (w/o any ETL intervention), by the described interva...
Live Traffic Stats
Post a Comment