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?
- 2 Answers
- 7331 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Informatica Checkpoints
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is the cumulative sum and moving sum?
What is flashback table ? Advance thanks
What is the difference between stop and abort in informatica
What is informatica?
State the differences between sql override and lookup override?
how tokens will generate?
What is a rank transform?
Explain pushdown optimization and types in informatica
how to load rows into fact table in data warehouse
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
is it possible to index the data in cache of lkp transformation ?
