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 components used in smp and massively parallel processing (mpp) machines?

1004


What are the main components of teradata system?

1068


How to view every column and the columns contained in indexes in teradata?

982


What are the available primary index types?

1150


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

888


if collect stats but it show low confidence why?

1621


What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

1059


What are different table types used in teradata?

981


Explain teradata vs. Redshift?

958


How many types of joins are there in teradata?

915


Can you connect multiload from ab initio?

1138


How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1725


What are the newly developed features of Teradata?

973


Difference between inner join and outer join?

953


Explain the most common data types used in teradata?

988