Rakesh

• Jul 26th, 2017

Rule 1: Information Rule The data stored in a database, may it be user data or metadata, must be a value of some table cell. Everything in a database must be stored in a table format. Rule 2: Guar...

Ankal

• Oct 14th, 2011

11 1/2 or 12 codd's rules support

Answer Question  Select Best Answer

saiteja

• Jun 29th, 2017

FSLDM: stands for Financial Service Logical Data Modelling mainly it is used designing for the financial sectors and banking sectors...

Vijaylaxmi

• May 31st, 2012

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

Answer Question  Select Best Answer

What is log table? What is the use of log table?

saiteja

• Jun 29th, 2017

Log table maintain records of all checkpoints log table is used for restartability

yuvaevergreen

 Profile Answers by yuvaevergreen Questions by yuvaevergreen

• Oct 7th, 2010

Log table in MLOAD is used to store the results of each phase of the operation. This log table is used by MLOAD for restarting the mload process from the appropriate checkpoint i.e. after the successful phase.

Answer Question  Select Best Answer

Why fastload does not support multiset table and duplication?

saiteja

• Jun 16th, 2017

Fastload does not support duplicates because storing duplicates in fastload is difficult to the system decreases the performance of the fastload when the fastload script fails when you restart the fastload script and the same row hash value is loaded in to second time

senthang

 Profile Answers by senthang Questions by senthang

• Jun 22nd, 2011

Fastload will support the MULTISET table but it will ignore the all row duplicates because of the restartability mechanism of fastload.

Answer Question  Select Best Answer

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?

Read Best Answer

Editorial / Best Answer

SHUBH25  

 Profile Answers by SHUBH25 Questions by SHUBH25

• Member Since Feb-2008 | Feb 15th, 2008

---

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 Application Phase error table, to store data errors found during the application phase of a MultiLoad import or delete task

3. WORK TABLE - WT

Mload loads the selected records in the work table

4. LOG TABLE

A log table maintains record of all checkpoints related to the load job, it is essential/madatory to specify a log table in mload job. This table will be useful in case you have a job abort or restart due to any reason.

Shubhangi

CHetan

• Jun 9th, 2017

There are 2 error tables in Fastload, Error table 1 significance is to capture datawhich do not match the speciied datatype, and Error table 2 is for the Uniqueness constraint.. In case you have UPI d...

prasadh

• Oct 10th, 2014

In fload and multi load we have 2 error tables for a target table, if script run successfully with return code 0 we can see the error tables data(no errors tables will dropped).
tables are locked if script fails we can't see them its under loading....

Improve Answer

CHetan

• Jun 9th, 2017

If you are looking at high volume data in that case Fastload would give better performance. since Fastload would work in 2 phases whereas Multiload will have 5 for the same. But we are looking at low volume data then you have TPump as another option.

Bhargav

• May 22nd, 2016

What is Performance issues we considered while Execute the large amount data(Load the data from Files to Teradata Database)

Answer Question  Select Best Answer

What is the meaning of skewness in Teradata? When do we use nullif function in Teradata?

arunFERGY

 Profile Answers by arunFERGY Questions by arunFERGY

• May 31st, 2017

Unequal distribution of data on amps is called skewness. Nullif function compares two arguments, if they matches then it returns null else it returns first argument.

msrakesh

• Mar 29th, 2012

When we choose wrong primary index the data unevenly distributed across all the amps means some amps have more records and some amps had less records this is called skewness.
Percentage of skewness is called skew factor.30% skew factor is acceptable.

Answer Question  Select Best Answer

How will you avoid Skewness?

arunFERGY

• May 25th, 2017

Unequal distribution of data on amps is called skewness. Choose PI columns as unique as possible to avoid this.

debojitpal

 Profile Answers by debojitpal Questions by debojitpal

• Feb 1st, 2011

Data or Amp skew occurs in teradata due to uneven distribution of data accross all the amps. Often, this leads to spool space error too. To avoid skewness, try to select a Primary Index which has as m...

Answer Question  Select Best Answer

What are the difference between Teraadata Versions?

Kashyap

• Aug 25th, 2015

The following table shows how the Teradata Database optimizer can use indexes to enhance query performance. Index Type Standard Use primary index To satisfy an equality on an IN condition in a...

d

• Jun 25th, 2014

High Confidence: The stats are collected

Low Confidence : Stats are not collected but the used the index columns in where condition and join conditions

No Confidence : No stats and not used the index columns in where and join conditions

Answer Question  Select Best Answer

How do we configure ODBC and CLI in TERADATA systems.

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

rishabh gupta

• Sep 26th, 2014

Basically OLTP is used for normalized for efficient search & update to prevent redundancy.

Abhilash AS

 Profile Answers by Abhilash AS Questions by Abhilash AS

• Jan 11th, 2011

Best example is ATM Transactions...

Answer Question  Select Best Answer

Global Temporary tables (GTT) -1. When they are created, its definition goes into Data Dictionary.2. When materialized data goes in temp space.3. thats why, data is active upto the session ends, and definition will remain there upto its not dropped using Drop table statement.If dropped from some other session then its should be Drop table all;4. you can collect stats on GTT.Volatile Temporary tables...

Bikhayat kumar

• Feb 10th, 2014

GTT takes up space from temporary space where as VTT takes up space from spool. GTT survive TD system restarts where as VTT does not. GTT allows index to be created where as VTT does not. In a sing...

Prashant Nile

• Dec 13th, 2013

GTT uses the Temp Space where as Volatile table use the Spool Space. Both are Session Based once you logged of Data gets vanished. For GTT Definitions remains as it is, as it gets stored in Data Di...

Answer Question  Select Best Answer

What is an optimization and performance tuning and how does it really work in practical projects. can i get any example to better understand.

tdguy

• May 22nd, 2013

Performance tuning:
1. Look at the plan generated by PE.
2. Check for the recommendations of stats to be collected for the columns.
3. Try to avoid product joins and unnecessary joins.
4. Try to avoid casting in join conditions
5. Use secondary index appropriately.
6. Use join index if necessary.

debashish.munshi

 Profile Answers by debashish.munshi Questions by debashish.munshi

• Sep 18th, 2012

Optimization of queries improves performance of TD and helps the PE to generate the most efficient execution plan. To Optimize a query, choose the Primary Index to avoid skrew, Collect statistics on t...

Answer Question  Select Best Answer

There are 2 tables, table A with 10 million records, table B has 100 million records, now we are joining both tables, when we seen Explain Plan the plan showing TD will took the table A and it will redistributes itNow the Question is: By that plan is the optimizer is correct job or not ? Justify Ans2. From the same above example now the optimizer is taking Table B (100 million records) and it is distributing...

yuvaevergreen

• May 22nd, 2013

Merge join strategies are 1. Big and small table joins - duplicate small tables 2. Column used in join is PI for one table - redistribute the other table in spool. 3. Column used in join is non PI f...

• Sep 18th, 2012

There are 2 tables, table A with 10 million records, table B has 100 million records, now we are joining both tables, when we seen Explain Plan the plan showing TD will took the table A and it will re...

Answer Question  Select Best Answer

What are the differences between the followings?- Vertical & Horizontal Partitioningvs- Join & Hash Indexes vs- PPI

yuvaevergreen

• May 20th, 2013

Horizontal partitioning is used in large tables where no of rows are very high. Rows are broken and placed in partitions. Loading becomes faster and query performance would be good. Vertical partitio...

sureshkuncham

• Nov 16th, 2012

PPI does not support any join index and hash index

Answer Question  Select Best Answer

shams756

• Nov 2nd, 2012

V2R6 FEATURES
1. Queue Tables are added.
2. Triggered Stored Procedure added.
3. Stored Procedure Grammar Merge added.
4. Multi statements request submitted (supported in stored
procedures by using
BEGIN REQUEST
------
END RESQUEST.

navneet_iway

 Profile Answers by navneet_iway Questions by navneet_iway

• Jun 11th, 2008

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.

Answer Question  Select Best Answer

debashish.munshi

 Profile Answers by debashish.munshi Questions by debashish.munshi

• Sep 18th, 2012

Basic Teradata Query Language or Batch Teradata Query Language is one of the effective utility in teradata. As using BTEQ we can write SQL statements in Interactive as well as Batch modes. using Bteq you can also Import Export data. Although for Importing and Exporting you have other utilities.

krishna

• Jul 30th, 2012

Hello readers
it is just like sql assistance, but giving better performance then sql assistance, bteq work in from host (cli) where as sql runs from odbc so it having lot more opses (gateway) so gives some what less then bteq.

Answer Question  Select Best Answer

How many version is there in Teradata? please give me detail information for version ? Version Name and Particular date ?

sunil

• Mar 24th, 2012

The following are Teradata Versions as I known.

1. Teradata v2r5
2. Teradata v2r6
3. Teradata 12
4. Teradata 13
5. Teradata 13.10
6. Teradata 14

Now Teradata 14 is the latest one, Teradata 14.10 is upcoming release

Answer Question  Select Best Answer

Each Foreign Key must exist as a Primary Key.Foreign Keys can change values over time.

thirupathi

• Jan 5th, 2012

The utilities are in teradata as follows

Bteq for loadind/Unloading the data

Fload for load the data only one table at a time it must be empty

mload for load the data which is empty or populated table up to 5 tables at a time

fexport to export the data

tpump to load the data upto 64 tables

shahid

• Nov 21st, 2011

Both statements are TRUE

Answer Question  Select Best Answer