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 the use of an aggregator cache file?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
EXL informatica Questions
In which transformation you cannot drag ports into it?
What are the main issues while working with flat files as source and as targets ?
Informatica Checkpoints
Explain the code page compatibility?
What is the use of code page?
What is the difference between writing a joiner query in ANSI style and THETA style?
How to handle decimal places while importing a flatfile into informatica?
During the running session, output files are created by informatica server. Enlist few of them.
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What are the different transaction levels available in transaction control transformation?
What is the need of an ETL tool?
how to load dimension table and fact table. plz tell me the steps.