CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions
Our Services
Get 9,000 Interview Questions & Answers in an eBook.




Get it now !!
Send your Resume to 6000 Companies
Teradata Interview Questions & Answers - Learning Mode
COOLINTERVIEW.COM DATABASE INTERVIEW QUESTIONS TERADATA INTERVIEW QUESTIONS QUESTIONS & ANSWERS - LEARNING MODE

Teradata Interview Questions & Answers - Learning Mode

Teradata is a relational database management system (RDBMS) that is: ? Teradata is an open system, running on a UNIX MP-RAS or Windows server platform. ? Teradata is capable of supporting many concurrent users from various client platforms. Teradata is a fully scalable relational database management system produced by Teradata Corp. It is widely used to manage large data warehousing operations.

Try Teradata Interview Questions & Answers - Exam Mode

1 2 Next

Sort By : Latest First | Oldest First | By Rating

Teradata Interview Questions & Answers - Learning Mode
Try Teradata Interview Questions & Answers - Exam Mode
Question: How many codd's rules are satisfied by teradata database?

Answer: There are 12 codd's rules applied to the teradata database Source: CoolInterview.com
Question: What is explain in teradata?

Answer: The EXPLAIN facility is a teradata extension that provides you with an "ENGLISH" translation of the steps choosen by the optimizer to execute an SQL statement.It may be used oin any valid teradata database with a preface called "EXPLAIN".<br><br>The following is an example:-<br><br> EXPLAIN select last_name,first_name FROM employees;<br><br>The EXPLAIN parses the SQL statement but does not execute it.<br><br>This provides the designer with an "exec Source: CoolInterview.com
Question: what is basic teradata query language?

Answer: BTEQ(Basic teradata query)

It allows us to write SQL statements along with BTEQ commands. We can use BTEQ for importing,exporting and reporting purposes.

The commands start with a (.) dot and can be terminated by using (;), it is not mandatory to use (;). SQL statements doesnt start with a dot , but (;) is compulsary to terminate the SQL statement.

BTEQ will assume any thing written with out a dot as a sql statement and requires a (;) to terminate it. Source: CoolInterview.com
Question: What is the difference between Multiload & Fastload interms of Performance?

Answer: If you want to load empty table then you use the fastload, so it will very useful than the multiload because fastload performs the loading of the data in 2 phase and it no need a work table for loading the data, so it is faster as well as it follows the below steps to load the data in the table<br><br>Phase1-It moves all the records to all the AMP first without any hashing <br>Phase2-After giving endloading command, Amp will hashes the record and send it to the appropriate AMPS Source: CoolInterview.com
Question: How many error tables are there in fload and what are their significance/use?
Can we see the data of error tables?
How many error tables are their in mload and what is there use?
When mload job fails, can we access mload tables? If yes then how?


Answer: Fload uses 2 error tables

Error table 1: where format of data is not correct.


Error table 2: violations of UPI

Mload also uses 2 error tables (ET and UV), 1 work table and 1 log table

1. ET TABLE - Data error

MultiLoad uses the ET table, also called the Acquisition Phase error table, to store data errors found during the acquisition phase of a MultiLoad import task.

2. UV TABLE - UPI violations

MultiLoad uses the UV table, also called the Appl Source: CoolInterview.com
Question: Which two can be implemented as a centrally located logical architecture?

?operational data store

?logical data mart


Answer: 1- Logical Data Mart Repository

2- Provides a single version of the truth Source: CoolInterview.com
Question: How many codd's rules are satisfied by teradata database?

Answer: There are 12 codd's rules applied to the teradata database
Source: CoolInterview.com
Question: Does SDLC changes when you use Teradata instead of Oracle?

Answer: If you are going to use teradata instead of oracle



If the teradata is going to be only a data base means It won?t change the System development life cycle (SDLC)



If you are going to use the teradata utilities then it will change the Architecture or SDLC



If your schema is going to be in 3NF then there won?t be huge in change Source: CoolInterview.com
Question: Can we have an unconnected lkp to lookup a DB2 record against a Teradata record? doesnt seem to work. I could be wrong.

Answer: Yes we can ..but some times we need to check the value which lookup is returning .....like it happens in teradata if we are having lookup on varchar column and record is coming from source system it never works because when informatica creates cache from there it adds space to the values.so we always have to use ltrim(rtrim)) function in lookup query. Source: CoolInterview.com
Question: Does SDLC changes when you use Teradata instead of Oracle?



Answer: If you are going to use teradata instead of oracle



If the teradata is going to be only a data base means It won?t change the System development life cycle (SDLC)



If you are going to use the teradata utilities then it will change the Architecture or SDLC



If your schema is going to be in 3NF then there won?t be huge in change


Source: CoolInterview.com
Question: what is an optimization and performance tuning and how does it really work in practical projects. can i get any example to better understand.

Answer: Performance tuning and optimization of a query involves collecting statistics on join columns, avoiding cross product join, selection of appropriate primary index (to avoid skewness in storage) and using secondary index.

Avoiding NUSI is advisable. Source: CoolInterview.com
Question: How teradata makes sure that there are no duplicate rows being inserted when its a SET table?

Answer: Teradata will redirect the new inserted row as per its PI to the target AMP (on the basis of its row hash value), and if it find same row hash value in that

AMP (hash synonyms) then it start comparing the whole row, and find out if duplicate.
If its a duplicate it silently skips it without throwing any error.


Source: CoolInterview.com
Question: What is the difference between start schma and Fsldm?



Answer: FSLDM --> Financial Services Logical Data Model (Teradata FS-LDM 7.0) its developed by Teradata for the financial sectors (Speciafially for Bank). it can be customised based on the user requirement.

StarSchma --> Its a relational database schema for representing multidimensional data. The data is stored in a central fact table, with one or more tables holding information on each dimension.

So both are entirely different.

Source: CoolInterview.com
Question: Can we have an unconnected lkp to lookup a DB2 record against a Teradata record? doesnt seem to work. I could be wrong.

Answer: Yes we can ..but some times we need to check the value which lookup is returning .....like it happens in teradata if we are having lookup on varchar column and record is coming from source system it never works because when informatica creates cache from there it adds space to the values.so we always have to use ltrim(rtrim)) function in lookup query. Source: CoolInterview.com
Question: Can we have an unconnected lkp to lookup a DB2 record against a Teradata record? doesnt seem to work. I could be wrong.



Answer: Yes we can but some times we need to check the value which lookup is returning, like it happens in teradata if we are having lookup on varchar column and record is coming from source system it never works because when informatica creates cache from there it adds space to the values.so we always have to use ltrim(rtrim)) function in lookup query.

Source: CoolInterview.com
Question: How does indexing improve query performance?

Answer: Indexing is a way to physically reorganise the records to enable some frequently used queries to run faster.


The index can be used as a pointer to the large table. It helps to locate the required row quickly and then return ot back to the user.

or

The frequesntly used queries need not hit a large table for data. they can get what they want from the index itself. - cover queries.

Index comes with the overhead of maintanance. Teradata maintains its index by itself. Source: CoolInterview.com
Question: What is the difference between start schma and Fsldm?

Answer: FSLDM --> Financial Services Logical Data Model (Teradata FS-LDM 7.0) its developed by Teradata for the financial sectors (Speciafially for Bank). it can be customised based on the user requirement.

StarSchma --> Its a relational database schema for representing multidimensional data. The data is stored in a central fact table, with one or more tables holding information on each dimension. Source: CoolInterview.com
Question: Which two statements are true about a foreign key?

Each Foreign Key must exist as a Primary Key.

Foreign Keys can change values over time.


Answer: first : True
second : False Source: CoolInterview.com
Question: Which two can be implemented as a centrally located logical architecture?



Answer: 1. Provides a single version of the truth

2. Minimizes synchronization


Source: CoolInterview.com
Question: What is basic teradata query language?

Answer: It allows us to write SQL statements along with BTEQ commands. We can use BTEQ for importing,exporting and reporting purposes.

The commands start with a (.) dot and can be terminated by using (;), it is not mandatory to use (;). SQL statements doesnt start with a dot , but (;) is

compulsary to terminate the SQL statement.

BTEQ will assume any thing written with out a dot as a sql statement and requires a (;) to terminate it. Source: CoolInterview.com

1 2 Next



India News Network
Latest 20 Questions
Payment of time- barred debt is: (a) Valid (b) Void (c) Illegal (d) Voidable
Consideration is defined in the Indian Contract Act,1872 in: (a) Section 2(f) (b) Section 2(e) (c) Section 2(g) (d) Section 2(d)
Which of the following is not an exception to the rule, "No consideration, No contract": (a) Natural love and affection (b) Compensation for involuntary services (c) Completed gift (d) Agency
Consideration must move at the desire of: (a) The promisor (b) The promisee (c) The promisor or any other party (d) Both the promisor and the promisee
An offer which is open for acceptance over a period of time is: (a) Cross Offer (b) Counter Offer (c) Standing Offer (d) Implied Offer
Specific offer can be communicated to__________ (a) All the parties of contract (b) General public in universe (c) Specific person (d) None of the above
_________ amounts to rejection of the original offer. (a) Cross offer (b) Special offer (c) Standing offer (d) Counter offer
A advertises to sell his old car by advertising in a newspaper. This offer is caleed: (a) General Offer (b) Special Offer (c) Continuing Offer (d) None of the above
In case a counter offer is made, the original offer stands: (a) Rejected (b) Accepted automatically (c) Accepted subject to certain modifications and variations (d) None of the above
In case of unenforceable contract having some technical defect, parties (a) Can sue upon it (b) Cannot sue upon it (c) Should consider it to be illegal (d) None of the above
If entire specified goods is perished before entering into contract of sale, the contract is (a) Valid (b) Void (c) Voidable (d) Cancelled
______________ contracts are also caled contracts with executed consideration. (a) Unilateral (b) Completed (c) Bilateral (d) Executory
A offers B to supply books @ Rs 100 each but B accepts the same with condition of 10% discount. This is a case of (a) Counter Offer (b) Cross Offer (c) Specific Offer (d) General Offer
_____________ is a game of chance. (a) Conditional Contract (b) Contingent Contract (c) Wagering Contract (d) Quasi Contract
There is no binding contract in case of _______ as one's offer cannot be constructed as acceptance (a) Cross Offer (b) Standing Offer (c) Counter Offer (d) Special Offer
An offer is made with an intention to have negotiation from other party. This type of offer is: (a) Invitation to offer (b) Valid offer (c) Voidable (d) None of the above
When an offer is made to the world at large, it is ____________ offer. (a) Counter (b) Special (c) General (d) None of the above
Implied contract even if not in writing or express words is perfectly _______________ if all the conditions are satisfied:- (a) Void (b) Voidable (c) Valid (d) Illegal
A specific offer can be accepted by ___________. (a) Any person (b) Any friend to offeror (c) The person to whom it is made (d) Any friend of offeree
An agreement toput a fire on a person's car is a ______: (a) Legal (b) Voidable (c) Valid (d) Illegal
Cache = 0.03125 Seconds