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

Why MultiLoad Utility supports only Non Unique Secondary
Index(NUSI) in the Target Table ?

Answer Posted / hari m

WHAT EVER WE DISCUSSED ABOVE IS OK WITH THE MLOAD.

EVEN I AGREE WITH MLOAD, FLOAD HAS LIMITIATON AS USI, JI,
TRIGGERS MULITIPLE AMP OPERATIONS.


I have a quick question why FLOAD doesn't supports NUSI? As
posted above if Nusi is operations are within in same amp.

Please explain in this regard.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Highlight the need for Performance Tuning.

1113


Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?

1249


If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

2175


In BTEQ, how are the session-mode parameters being set?

1151


What are the primary characteristics of the Teradata.

1166


How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

4379


What are the different design perspectives used in teradata?

989


What is the syntax for case when statement?

1154


Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

3631


Describe the between keyword in teradata?

1044


Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?

1210


Explain the advantages of partitioned primary index in a query?

1030


Explain some differences between mpp and smp?

1110


What is the opening step in basic teradata query script?

1048


What are the various indexes in teradata? How to use them? Why are they preferred?

1069