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 9255

what is the difference between start schma and Fsldm?

Intel,

5 50023

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

IBM, Wipro,

2 12959

What are two examples of an OLTP environment?

4 14875

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

Wipro,

1 11404

Does SDLC changes when you use Teradata instead of Oracle?

2 11555

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

2 13124

How does indexing improve query performance?

Satyam,

4 20854

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

Cap Gemini, Intel,

8 47551

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

3 7061

What are the types of tables in Teradata

Cap Gemini, Cognizant, Infosys,

22 78599

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 8902

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 17818

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 29334

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

Accenture, CTS, NTT Data,

2 17218

Post New Teradata Questions

Un-Answered Questions { Teradata }

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

1100

What is collect statistics?

998

Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

1955

What is stored procedure in teradata?

1030

What is the maximum number of dml can be coded in a multiload script?

1109

How does hashing happens in teradata?

1091

why use references rather than pointers in the public api, particularly for arguments which are modified?

1006

What is meant by a dispatcher?

1021

any one answer me how they can analyzing the project using data ware housing?

2476

List out all forms of LOCKS that are available in Teradata.

969

Explain some differences between mpp and smp?

1100

What do you mean by teradata sql assistant?

1062

What is multi insert?

1049

What is a node in teradata? Explain

1009

tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

835

For More Un-Answered { Teradata } Questions Click Here