1. How many codd,s rules are satisfied by teradata database?

11 1/2 codd,s rule is supported by teradata.

2. What is Group by in Select statement?

Group by clause is used in Teradata to remove repetitive values in a column or group of columns, when we select result of a particular query. And it represent it as single entity.

3. What is stored procedure in Teradata?

A stored procedure is a group of SQL statements that form a logical unit and perform a particular task. Stored procedures are used to encapsulate a set of operations or queries to execute on a database server. For example, operations on an employee database (hire, fire, promote, lookup) could be coded as stored procedures executed by application code. Stored procedures can be compiled and executed with different parameters and results, and they may have any combination of input, output, and input/output parameters.

4. Can we have an unconnected lkp to lookup a DB2 record against a Teradata record? doesnt seem to work. I could be wrong.

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.

5. What is the difference between start schma and Fsldm?

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.......

6. Which two can be implemented as a centrally located logical architecture?

1. Provides a single version of the truth

2. Minimizes synchronization

8. What are two examples of an OLTP environment?

# Transactions take a matter of seconds or less.
# Many transactions involve a small amount of data.

On Line Banking
On Line Reservation (Transportation like Rail, Air etc.)

1- ATM
2- POS

OLTP is typified by a small number of rows (or records) or a few of many possible tables being accessed in a matter of seconds or less. Very little I/O

processing is required to complete the transaction. For eg.

1. This type of transaction takes place when we take out money at an ATM. Once our card is validated, a debit transaction takes place against our current

balance to reflect the amount of cash withdrawn.

2. This type of transaction also takes place when we deposit money into a checking account and the balance gets updated.

We expect these transactions to be performed quickly. They must occur in real time.

9. 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.

first : True
second : False
1. Foreign Keys can change values over time.
2. Each Foreign Key must exist as a Primary Key.

10. Does SDLC changes when you 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

Download Interview PDF