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 5563

what is the difference between start schma and Fsldm?

Intel,

5 35798

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

Wipro, IBM,

2 8504




What are two examples of an OLTP environment?

4 9238

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

Wipro,

1 7606

Does SDLC changes when you use Teradata instead of Oracle?

2 7454

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

2 9132

How does indexing improve query performance?

Satyam,

4 15361




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

Cap Gemini, Intel,

8 34067

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

3 3253

What are the types of tables in Teradata

Cognizant, Infosys, Cap Gemini,

22 55349

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 5132

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 9318

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 18425

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

NTT Data, Accenture, CTS,

2 10074


Post New Teradata Questions






Un-Answered Questions { Teradata }

If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

953


How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

2374


Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

2002


How to load specific no.of records using bteq, or fastload,or multiload

430


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

459






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

717


If a Node is busy what are the steps you can take to avoid ?

1113


Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

827


If RDBMS is halted what will you do ?

909


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

775


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

684


hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com

1542


how can we analyze the locks ?

875


Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

1102


what are the day to day activities of teradata DBA ?

4031