Highlight the differences between Primary Key and Primary Index.
No Answer is Posted For this Question
Be the First to Post Answer
Explain the most common data types used in teradata?
How to relege locks in fastload and multiload? example?
I want to load 1000 rcds using. FL for every 100 records there is a check point.But script failed at 120 records, when we are restarting the script, it starts from last ckpt, but Target table contains populated data but FL doesnt support existing data in target table. How can we load data in FL?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
1. generally how many node system will be used by the client. 2. while running mload if the job is aborted/failed at any phase what we have to look after to run the job successfully? 3.i wanted to know how to write the fastload script for table creation as well as table loading in a single script?
If table have access lock.In the same table write lock is posible or not?
What is the purpose of joins in teradata?
What are tpump utility limitations?
Can any one plz provide the teradata interview questions?
How does hashing happens in teradata?
What is spool space?
What are the different design perspectives used in teradata?