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

Where do you create/define mapping parameter and mapping variable?

1 Answers  


What the difference is between a database, a data warehouse and a data mart?

0 Answers  


hi i want to install latest informatica software in my pc..can anybody help me where should i get the infomatica software..plz help me

3 Answers  


Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??

3 Answers   IBM,


How can we improve session performance in aggregator transformation?

0 Answers   Informatica,


If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

0 Answers   IBM, TCS,


Can we insert ,update ,delete in target tables with one update strategy tran.?

2 Answers   Zensar,


what is diffrence b/w joner and union transfermation

6 Answers  


Define filter transformation?

0 Answers  


Tell me about informatica architecture.

2 Answers   TCS,


How many numbers of sessions can one group in batches?

0 Answers  


What is the Rankindex in Ranktransformation?

7 Answers  


Categories