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
Why filter transformation is an active one?
Could you explain what is enterprise data warehouse?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
In how many ways we can create ports?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
How do you load unique records into one target table and duplicate records into a different target table?
What are the new features of informatica 9.x at the developer level?
What is data transformation manager process?
What is a predefined event?
What is the Rank index port in Rank transformation?
What is rank transform?
how to load rows into fact table in data warehouse
What happens when a session fails and you click on recover?
What is lookup change?