A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
1259
Explain the parallel data extension in teradata?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
If RDBMS is halted what will you do ?
What are the different methods ot loading a dimension table? A fact table etc?
How many sessions of MAX is PE capable of handling at a particular time?
What is difference between user and database in teradata?
What are the available primary index types in teradata.
Why does varchar occupy 2 extra bytes?
any one answer me how they can analyzing the project using data ware housing?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
What interface is used to connect to windows based applications?
Highlight the differences between Primary Key and Primary Index.
Highlight the need for Performance Tuning.
How to load specific no.of records using bteq, or fastload,or multiload
How to Extract data from multiple legacy systems?