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 6540

what is the difference between start schma and Fsldm?

Intel,

5 40575

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

Wipro, IBM,

2 9722

What are two examples of an OLTP environment?

4 10526

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

Wipro,

1 8713

Does SDLC changes when you use Teradata instead of Oracle?

2 8237

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

2 10026

How does indexing improve query performance?

Satyam,

4 16799

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

Cap Gemini, Intel,

8 37665

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

3 3868

What are the types of tables in Teradata

Cognizant, Infosys, Cap Gemini,

22 60970

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 5987

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 10827

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 20426

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

NTT Data, Accenture, CTS,

2 11828


Post New Teradata Questions






Un-Answered Questions { Teradata }

what is sysdba and sysdbc ? which has high priority ?

2800


In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

93


What can be achieved by using the teradata rdbms?

88


What is the purpose of indexes?

99


What are the different table types supported by teradata?

86






Difference between multiload and tpump?

109


What is upsert statement in teradata?

79


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

763


Why teradata is used?

93


How many tables can you join in v2r5?

110


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

83


If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

1309


What is the use of fallback?

83


Highlight the limitations of TPUMP Utility.

83


What are the different functions performed in development phase?

78