Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is meant by MATCHTAG in multiload utility?

Answer Posted / tdguy

in multiload, five phases are involved. During the DML
phase, all the DML statements are processed. In the next
acquisition phase, the input data is handled and sent to
the worktables. In the fourth application phase, for the
proper sync of input data and DMLs, these match tags are
used. These details can be seen in the mload stats details.

ImportSeq - Sequence number that identifies the IMPORT
command where the error occurred.
DMLSeq - Sequence number for the DML statement involved
with the error
SMTSeq - Sequence number of the DML statement being
carried out when the error was discovered
ApplySeq - Sequence number that tells which APPLY clause
was running when the error occurred
SourceSeq - The number of the data row in the client file
that was being built when the error took place

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the uses of bynets in multi-node systems?

1031


List out all forms of LOCKS that are available in Teradata.

969


How many types of joins are there in teradata?

978


How do you see a ddl for an existing table?

1018


Can you fastexport a field, which is primary key by putting equality on that key?

1178


What is a node in teradata?

999


Difference between stored procedure and macro?

1172


What are the things to be considered while creating secondary index?

1101


Which is more efficient group by or distinct to find duplicates?

1090


Explain fallback in teradata?

1064


Explain vproc in teradata?

1003


What is smp and mpp platforms?

971


Explain teradata architecture?

1093


Describe the between keyword in teradata?

1040


Explain the term 'tables' related to relational database management system?

1049