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 9139

what is the difference between start schma and Fsldm?

Intel,

5 49700

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 14611

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 11405

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 20627

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

Cap Gemini, Intel,

8 47119

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

3 6888

What are the types of tables in Teradata

Cap Gemini, Cognizant, Infosys,

22 77697

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 8755

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 28720

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

Accenture, CTS, NTT Data,

2 17035

Post New Teradata Questions

Un-Answered Questions { Teradata }

Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

1017

What is a clique?

1011

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

1997

What do you mean by fastexport in teradata?

939

What are the main components of teradata system?

1066

What is the use of teradata system software?

983

how do you manage the production space. what are the proactive methods you can take ?

1880

What is meant by Teradata Gateway?

1002

What is meant by a Clique?

989

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

956

What do you mean by ttu in teradata?

972

What is upsert statement in teradata?

1051

What is the purpose of indexes?

1010

Difference between inner join and outer join?

951

What do high confidence, low confidence and no confidence mean in explain plan?

980

For More Un-Answered { Teradata } Questions Click Here