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?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2137


State the differences between sql override and lookup override?

1209


hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

2107


What is sq transformation?

1163


where to store informatica rejected data?

1094


5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1914


Explain pushdown optimization and types in informatica

1079


Separate from an archive server and a powerhouse?

964


Can we create two repositories on same database instance in oracle?

1095


What is meant by target load plan?

974


What is the need of etl tools?

1120


What are the transformations that are not supported in mapplet?

1032


How do you take back up of repository?

1162


HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1903


What will be the approach?

980