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

which memory is used by lookup and join

Answer Posted / subbuchamala

-->LOOK-UP runs based on physical memory(RAM).

While doing Look-Up, Data will be loaded into the Physical Memory(RAM) which faster and better for LOW Valume of data.


-->JOIN Uses the Buffer Memory(disc memory)

Buffer Memory(disc memory)--> this path is specified in the Configuration file and parameter name is: SCRATCH DISK path

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the repository tables in datastage?

1256


What are stage variables and constants?

1095


Why fact table is in normal form?

1147


how to sort two columns in single job in datastage.

2840


what is use of SDR function?

5126


How can we improve performance of data stage jobs?

966


What are the important features of datastage?

1048


What are the components of ascential data stage?

1110


Explain connectivity between datastage with datasources?

938


Define Data Stage?

1040


What could be a data source system?

939


Define Routines and their types?

1095


To see hidden files in LINIX?

1450


What is quality stage?

937


what is the use of materialized view?

1486