Teradata Interview Questions
Questions Answers Views Company eMail

We are migrating an oracle table into teradata, the volume of data is huge and partitioned (year wise list partition). How do i simulate the same in teradata.

IBM,

2 6042

why should we go Teradata over Oracle,what is the main differences?

TCS,

4 10353

How do you load Multiple files to a table by using fastload scripts?

Satyam,

1 11012

Aborted in Phase 1 data Acquistion Incomplete in fastload?

2 4536

Aborted in Phase 2 data acquistion completed in fastload?

2 4758

Fast Load Script is failed and error tables are available then how do you restart?

TCS,

3 13785

How do you Generate Sequence in Teradata?

TCS,

3 14438

How do you Generate sequence at the time of Display?

Infosys,

2 7151

There is a load to the Table every one hour and 24/7.Morning trafic is high, afternoon trafiic is less, Night trafiic is high.According to this situation which Utility you use and how do you load,which utility used?

IBM,

4 7522

Why Multiload and Fastload does not supports SI,JI,RI and TRIGGERS?

4 11153

Why Multiload does not supports USI and supports NUSI?

4 19658

How to run the Teradata jobs in unix environment ???

IBM,

4 14940

which join mostly use in realtime?

TCS,

2 7058

How to copy teradata scripts from ur remote desktop to server machine?

3 6369

how to load or extract the error table data ?

3 6404


Post New Teradata Questions

Un-Answered Questions { Teradata }

What are normalization, first normal form, second normal form and third normal form?

603


What is the purpose of joins in teradata and what are the available join types?

522


What are the various etl tools in the market?

552


What is the syntax for case when statement?

566


What are the steps to create a data model?

576






What are the different table types that are supported by teradata?

521


Explain and compare pros and cons of start schemas?

521


What are the advantages of teradata?

574


What are the 5 phases in a multiload utility?

590


When tpump is used instead of multiload?

596


What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?

526


What are aggregate tables? How do you design them using teradata?

610


How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

3883


In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

556


What is a dimension table?

585