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

V2R6 included the feature of replica in it.in which copy of data base are available on another system.meam V2R6 provide the additional data protaction as comprison to V2R5 while if data from one system has been vanishes. After creating tables... Read More

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

The GRANT option for any particular table depends on the privilages of the user. If it is an admin user you can grant privilages at any point of time. The deafult roles associated with the newly created tables depend on he schema in which they... Read More

The Error Table contains information concerning: - Data conversion errors Constraint violations and other error conditions: * Contains rows which failed to be manupulated due to constraint violations or Transalation error * Captures rows that... Read More

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

There are 12 codd's rules applied to the teradata database Read More

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

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

Optimization is the technique of selecting the least expensive plan (fastest plan) for the query to fetch results. Optimization is directly proportional to the availibility of -- 1. CPU resources 2. Systems resources - amps PEs etc. Teradata... Read More

There are 12 codd's rules applied to the teradata database Read More

If you want to load, empty table then you use the fastload, so it will very usefull than the mutiload..because fastload performs the loading of the data in 2phase..and it noneed a work table for loading the data.., so it is faster as well as it... Read More

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

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

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

A clique is a set of Teradata nodes that share a common set of disk arrays. Cabling a subset of nodes to the same disk arrays creates a clique. Each AMP vproc must have access to an array controller, which in turn accesses the physical... Read More

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

It is stage3 - Predicting: Sophisticated analysts heavily utilize the system to leverage information to predict what will happen next in the business to proactively manage the organization’s strategy. This stage requires data mining tools and... Read More

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

1- Logical Data Mart Repository 2- Provides a single version of the truth Read More

first : True second : False Read More

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

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

 clique is a set of Teradata nodes that share a common set of disk arrays. Cabling a subset of nodes to the same disk arrays creates a clique. Each AMP vproc must have access to an array controller, which in turn accesses the physical disks.... Read More

The two expamples of OLTP are: 1- ATM. 2- POS. Read More

The GRANT option for any particular table depends on the privilages of the user. If it is an admin user you can grant privilages at any point of time. The deafult roles associated with the newly created tables depend on he schema in which they are... Read More

ODS=>Operational Data Source Read More