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 9138

what is the difference between start schma and Fsldm?

Intel,

5 49696

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

IBM, Wipro,

2 12794

What are two examples of an OLTP environment?

4 14610

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

Wipro,

1 11300

Does SDLC changes when you use Teradata instead of Oracle?

2 11404

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

2 12987

How does indexing improve query performance?

Satyam,

4 20624

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

Cap Gemini, Intel,

8 47117

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

3 6886

What are the types of tables in Teradata

Cap Gemini, Cognizant, Infosys,

22 77688

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 8754

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 17433

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 28717

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

Accenture, CTS, NTT Data,

2 17035

Post New Teradata Questions

Un-Answered Questions { Teradata }

What is meant by a Parsing Engine?

1128

What's the difference between timestamp (0) and timestamp (6)?

1122

What are the functions involved in shared information architecture?

1016

What are the multiload utility limitations?

1002

What are the various etl tools in the market?

1016

Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

931

How do you set the session mode parameters in bteq?

1031

What are some primary characteristics of teradata?

943

What are types of partition primary index (ppi) in teradata?

998

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1723

Explain some differences between mpp and smp?

1035

What is the use of having index on table?

951

What are the various indexes in teradata? How to use them? Why are they preferred?

996

Can you connect multiload from ab initio?

1135

What is oltp?

914

For More Un-Answered { Teradata } Questions Click Here