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 49996

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

IBM, Wipro,

2 12941

What are two examples of an OLTP environment?

4 14855

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 11529

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

2 13107

How does indexing improve query performance?

Satyam,

4 20830

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

Cap Gemini, Intel,

8 47480

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

3 7036

What are the types of tables in Teradata

Cap Gemini, Cognizant, Infosys,

22 78468

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 8876

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 17770

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 29258

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

Accenture, CTS, NTT Data,

2 17198

Post New Teradata Questions

Un-Answered Questions { Teradata }

Highlight a few of the important components of Teradata?

1025

If RDBMS is halted what will you do ?

2156

How to find duplicates in a table?

1204

What is meant by a Highest Cost Plan?

1055

In general, how do you optimze any sql in teradata?

1039

What are the available primary index types in teradata.

1028

How do you verify a complicated sql?

1057

Difference between multiload and tpump?

1094

While creating table my dba has fallback or no fallback in his ddl. What is that?

1173

Difference between star and snowflake schemas?

1141

What are the design features involved in teradata?

1050

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

1072

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2412

Highlight the need for Performance Tuning.

1103

How do you set the session mode parameters in bteq?

1097

For More Un-Answered { Teradata } Questions Click Here