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

Can i create a lookup table without cache.

Answer Posted / saif

uncheck the caching option.
it will hit the database for each source record.
it will give good performance in case of incremental load
(which normally process less number of rec) but for full
load it may not.

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are pre and post-session shell commands?

1377


Performance tuning in UNIX for informatica mappings?

2620


Name at least 5 different types of transformations used in mapping design and state the use of each.?

1194


What is meant by incremental aggregation?

1176


-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5870


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

2043


What is meant by query override?

1112


What is dynamic cache?

1079


Differentiate between a database and data warehouse?

1187


What are the differences between source qualifier and joiner transformation?

1132


Describe data concatenation?

1117


What are the different types of repositories created using informatica?

1168


Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1141


How many ways are there to create ports?

1399


What is workflow? What are the components of workflow manager?

1230