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

how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

2375


what is use of SDR function?

5176


How do u convert the columns to rows in datastage?

1194


What is ds designer?

1107


Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

3250


Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

781


Why do we use exception activity in Datastage?

1317


how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3347


What is merge stage?

1318


Is the value of staging variable stored temporarily or permanently?

1000


how to write server Routine coding?

2132


How a source file is populated?

1068


How will you move hashed file from one location to another location?

2154


Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

3167


What is ibm datastage?

971