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 9158

what is the difference between start schma and Fsldm?

Intel,

5 49746

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

IBM, Wipro,

2 12817

What are two examples of an OLTP environment?

4 14654

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

Wipro,

1 11323

Does SDLC changes when you use Teradata instead of Oracle?

2 11423

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

2 13010

How does indexing improve query performance?

Satyam,

4 20666

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

Cap Gemini, Intel,

8 47173

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

3 6912

What are the types of tables in Teradata

Cap Gemini, Cognizant, Infosys,

22 77828

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 8777

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 17488

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 28805

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

Accenture, CTS, NTT Data,

2 17069

Post New Teradata Questions

Un-Answered Questions { Teradata }

What is real time and near real time data warehousing?

1073

In Teradata, how do we Generate Sequence?

989

What are the available primary index types in teradata.

987

What are the components provided on node?

989

What is the function of parser component in teradata?

1047

What tools would you use for that?

1043

Which is faster fastload or multiload?

1049

What are the various indexes in teradata? Why are they preferred?

963

What are the different table types supported by teradata?

900

Highlight the advantages of PPI(Partition Primary Index).

1019

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

2007

What is meant by a dispatcher?

965

What are the components used in smp and massively parallel processing (mpp) machines?

1011

Differentiate primary key and partition key?

945

Can we collect statistics on table level?

994

For More Un-Answered { Teradata } Questions Click Here