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


If we have lookup table in workflow how do you trouble
shhot to increase performance?

Answers were Sorted based on User's Feedback



If we have lookup table in workflow how do you trouble shhot to increase performance?..

Answer / deepak aggarwal

You can calculate the size of lookup cache file needed
from number of rows and colulmn width needed. You can
increase Cache file size for good performance.

Is This Answer Correct ?    1 Yes 0 No

If we have lookup table in workflow how do you trouble shhot to increase performance?..

Answer / priya

There are 2 ways :
1. Create a persistant cache
2. Add the lookup table in SQ make it outer joined

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Informatica Interview Questions

what is diff between grep and find

3 Answers   IBM, iFlex,


If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?

4 Answers  


what is the need of session partitioning... how it is useful in real time

3 Answers   Amazon,


How to run a session, which contains mapplet?

1 Answers  


IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

0 Answers  


What is joiner transformation?

0 Answers  


What is incremental aggregation and how it is done?

8 Answers   JPMorgan Chase, TCS,


Can we use the mapping parameters or variables created in one mapping into another mapping?

1 Answers   Informatica,


why we use source qualifier transformation?

16 Answers   Accenture,


What is up date strategy and what are the options for update strategy?

2 Answers  


Enlist the differences between database and data warehouse.

0 Answers  


How can we improve session performance in aggregator transformation?

0 Answers   Informatica,


Categories