Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 5174

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

TCS,

4 8710

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

Satyam,

1 9368

Aborted in Phase 1 data Acquistion Incomplete in fastload?

2 3772

Aborted in Phase 2 data acquistion completed in fastload?

2 3845

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

TCS,

3 11601

How do you Generate Sequence in Teradata?

TCS,

3 12214

How do you Generate sequence at the time of Display?

Infosys,

2 5957

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 6180

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

4 9702

Why Multiload does not supports USI and supports NUSI?

4 15663

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

IBM,

4 13148

which join mostly use in realtime?

TCS,

2 5708

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

3 5255

how to load or extract the error table data ?

3 5404


Post New Teradata Questions






Un-Answered Questions { Teradata }

What are the various etl tools in the market?

189


Highlight the advantages of PPI(Partition Primary Index).

173


Is multi insert ansi standard?

227


Name the five phases that come under MultiLoad Utility.

174


Write a program to show the parser component used in teradata?

175






How is the teradata different from oracle?

178


Difference between stored procedure and macro?

199


Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

1234


What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

195


How to find duplicates in a table?

182


Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

162


What is the purpose of using case expression in teradata?

176


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?

182


What is the use of having index on table?

176


Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

2449