Teradata Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Teradata Interview Questions

Questions Answers Views Company eMail

can we have an unconnected lkp to lookup a DB2 record against a Teradata record?

IBM,

1 9160

what is the difference between start schma and Fsldm?

Intel,

5 49746

In which phase of the Active Data Warehouse evolution do you use data to determine what will happen?

IBM, Wipro,

2 12820

What are two examples of an OLTP environment?

4 14657

What is a common data source for the central enterprise data warehouse?

Wipro,

1 11323

Does SDLC changes when you use Teradata instead of Oracle?

2 11425

How can we build data marts from FSLDM. is there any standard approach for this?Is FSLDM supports place ?

2 13013

How does indexing improve query performance?

Satyam,

4 20670

What is the diffrence between Multiload & Fastload interms of Performance?

Cap Gemini, Intel,

8 47181

can we have an unconnected lkp to lookup a DB2 record against a Teradata record?

3 6918

What are the types of tables in Teradata

Cap Gemini, Cognizant, Infosys,

22 77865

IN A TABLE CAN WE USE PRIMARY KEY IN ONE COLUMN AND IN ANOTHER COLUMN BOTH UNIQUE AND NOT NULL CONSTRAINS.IF YES HOW?PLZ GIVE ME A EXAMPLE.

2 8780

IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A SAME TABLE?PLZ HELP ME BY GIVING THE ANSWER.THANK U.

10 17502

I WANT TO LEARN TERA-DATA ,SO CAN ANY BODY PLZ REFER WHAT ARE THE TOPICS I HAVE TO GO THROUGH, TO GET ASAP JOB ,SO PLZ REFER ME WHERE I CAN GET NICE COACHING ON TERADATA.

13 28815

can I use “drop” statement in the utility “fload”?

Accenture, CTS, NTT Data,

2 17074

Post New Teradata Questions

Un-Answered Questions { Teradata }

What are the scenarios in which full table scans occurs?

955

What is teradata?

1071

What type of indexing mechanism do we need to use for a typical data warehouse?

1092

What are the steps involved in the process flow of the sql statement through channel attached system?

1061

What is the command in bteq to check for session settings ?

1127

hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com

2806

What is spool space? Why do you get spool space errors? How do trouble-shoot them?

944

How teradata makes sure that there are no duplicate rows being inserted when its a set table?

939

i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com

2162

If RDBMS is halted what will you do ?

2113

How many sessions of MAX is PE capable of handling at a particular time?

1038

How to run a query in teradata?

1016

Explain the types of join supports by teradata?

941

If a Node is busy what are the steps you can take to avoid ?

2357

What is primary index and secondary index?

984

For More Un-Answered { Teradata } Questions Click Here