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 9245

what is the difference between start schma and Fsldm?

Intel,

5 49990

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

IBM, Wipro,

2 12940

What are two examples of an OLTP environment?

4 14853

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

Wipro,

1 11388

Does SDLC changes when you use Teradata instead of Oracle?

2 11526

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

2 13105

How does indexing improve query performance?

Satyam,

4 20825

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

Cap Gemini, Intel,

8 47473

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

3 7033

What are the types of tables in Teradata

Cap Gemini, Cognizant, Infosys,

22 78452

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 8872

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 17769

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 29248

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

Accenture, CTS, NTT Data,

2 17194

Post New Teradata Questions

Un-Answered Questions { Teradata }

What does sleep function does in fast load?

1129

What is difference between user and database in teradata?

1063

Explain how spool space is used.

1068

What is inner join and outer join?

1102

How to load specific no.of records using bteq, or fastload,or multiload

1740

What is the use of virtual processor connectivity in teradata?

996

Can you fastexport a field, which is primary key by putting equality on that key?

1173

My table got locked during mload due to a failed job. What do I do to perform other operations on it?

1094

What is a dimension table?

1049

Explain vproc in teradata?

991

How is the teradata different from oracle?

1094

How would you load a very large file in teradata in general? What utility would you use for it? Why?

1093

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

1078

Difference between stored procedure and macro?

1164

Describe the between keyword in teradata?

1029

For More Un-Answered { Teradata } Questions Click Here