What are aggregate tables? How do you design them using teradata?
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 a Node is busy what are the steps you can take to avoid ?
What are normalization, first normal form, second normal form and third normal form?
What are the joins in teradata and how many types of joins are there in teradata?
Discuss the advantages of using partitioned primary index in a query?
plz explain parlla distribution and subtable concept in teradata
which join mostly use in realtime?
I have a table with emp id, emp name, dept id and sal where dept id is NUSI. SEL * FROM EMP WHERE DEPTID = 100. Can any one explain how it will fetch the record.
Can we collect statistics on table level?
What are the design features involved in teradata?
What is teradata?
What is the use of having index on table?