I have a scenario with lookup table. in that lookup table have
colomns, but i need to process only 10 colomns out of 50.
Please te me how can we acheive it?
Answer Posted / prabhu
You can delete all unused columns from lookup.Then lookup
will create cache only on columns in lookup.This will
improve the performance too.
Prabhu
www.iskilltech.com
Is This Answer Correct ? | 17 Yes | 0 No |
Post New Answer View All Answers
What is meant by lookup transformation?
How to load a Dimension ? and how to load a fact table?
How to generate sequence numbers?
what is degenerated dimension?
What is the use of transformation?
Can informatica load heterogeneous targets from heterogeneous sources?
Why filter transformation is an active one?
What are the measure objects?
Difference between Data and Index Caches?
In warehouses how many schemas are there?
What is DR strategy for Informatica project?
What is the use of an aggregator cache file?
What is meant by LDAP users?
have u done any performance tuning? how u ll do?
What is dynamic cache?