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 7901

what is the difference between start schma and Fsldm?

Intel,

5 46643

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

IBM, Wipro,

2 11271

What are two examples of an OLTP environment?

4 12522

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

Wipro,

1 10133

Does SDLC changes when you use Teradata instead of Oracle?

2 9893

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

2 11524

How does indexing improve query performance?

Satyam,

4 18778

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

Cap Gemini, Intel,

8 43441

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

3 5252

What are the types of tables in Teradata

Cap Gemini, Cognizant, Infosys,

22 68759

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 7388

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 14319

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 24621

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

Accenture, CTS, NTT Data,

2 15043


Post New Teradata Questions

Un-Answered Questions { Teradata }

List out teradata data types?

461


What are some primary characteristics of teradata?

456


What is difference between user and database in teradata?

526


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?

576


What are different table types used in teradata?

486






Describe primary index in teradata?

488


Explain the term 'tables' related to relational database management system?

514


Can we collect statistics on table level?

507


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

490


What are the various indexes in teradata?

479


What is the syntax for case when statement?

498


What are the string manipulation operators and functions associated with teradata?

532


What are the different methods ot loading a dimension table? A fact table etc?

482


How do you determine the number of sessions?

512


How is the teradata different from oracle?

504