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
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
State the differences between sql override and lookup override?
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
What is sq transformation?
where to store informatica rejected data?
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
Explain pushdown optimization and types in informatica
Separate from an archive server and a powerhouse?
Can we create two repositories on same database instance in oracle?
What is meant by target load plan?
What is the need of etl tools?
What are the transformations that are not supported in mapplet?
How do you take back up of repository?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What will be the approach?