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 6245

what is the difference between start schma and Fsldm?

Intel,

5 39406

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

Wipro, IBM,

2 9427




What are two examples of an OLTP environment?

4 10126

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

Wipro,

1 8439

Does SDLC changes when you use Teradata instead of Oracle?

2 8024

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

2 9742

How does indexing improve query performance?

Satyam,

4 16343




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

Cap Gemini, Intel,

8 36620

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

3 3643

What are the types of tables in Teradata

Cognizant, Infosys, Cap Gemini,

22 59132

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 5780

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 10305

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 19729

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

NTT Data, Accenture, CTS,

2 11331


Post New Teradata Questions






Un-Answered Questions { Teradata }

How many sessions of MAX is PE capable of handling at a particular time?

17


Explain how spool space is used.

15


What is a level of granularity of a fact table?

14


What are the steps involved after the disk manager passes the request?

3


Highlight the differences between Primary Key and Primary Index.

17






What is meant by a Least Cost Plan?

15


What's the syntax of sub string?

17


What is meant by a Clique?

23


What are the things to be considered while creating secondary index?

15


How can you track login parameters of users in teradata?

11


What does sleep function does in fast load?

19


Why are oltp database designs not generally a good idea for a data warehouse?

12


Difference between inner join and outer join?

20


What are the different softwares used with their functions in teradata?

1


What is the particular designated level at which a LOCK is liable to be applied in Teradata?

16