-
Fload, Mload and error tables
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- 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 errorMultiLoad 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.
ShubhangiCHetan
- 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.... -
Teradata performance tuning and optimization
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
- 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...
-
what is basic teradata query language?
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.
