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 6332

what is the difference between start schma and Fsldm?

Intel,

5 39677

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

Wipro, IBM,

2 9509




What are two examples of an OLTP environment?

4 10234

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

Wipro,

1 8503

Does SDLC changes when you use Teradata instead of Oracle?

2 8083

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

2 9803

How does indexing improve query performance?

Satyam,

4 16450




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

Cap Gemini, Intel,

8 36865

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

3 3689

What are the types of tables in Teradata

Cognizant, Infosys, Cap Gemini,

22 59508

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 5833

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 10410

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 19870

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

NTT Data, Accenture, CTS,

2 11467


Post New Teradata Questions






Un-Answered Questions { Teradata }

What do you mean by fastexport in teradata?

13


How do you create tables? Exact syntax, and create profiles, users in teradata?

13


What is multi insert?

29


What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

27


What does Amp contain and what are all the operations that it performs?

31






Name the five phases that come under MultiLoad Utility.

31


When tpump is used instead of multiload?

31


What is the primary index in teradata?

8


What is spool space? Why do you get spool space errors?

11


How can we check the version of Teradata that we are using currently?

31


What are the uses of client software involved in teradata?

19


What is upsert statement in teradata?

15


Different phases of multiload?

32


Can we collect statistics on table level?

33


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

13