if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?
Answer Posted / ankit kansal
Unconnected Lookup is a better option as It will fire a sequel query whenever it was being called from other transformation using :LKP.lkp_trans(fieldname).
Or
Create a persistence cache for that table if it's not getting updated frequently. and use this cache in different other jobs.
http://deepinopensource.blogspot.in/
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between a connected look up and unconnected lookup?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
what is informatica metadata?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What is dimensional table? Explain the different dimensions.
Enlist the advantages of informatica.
Separate from a database, an information bazaar, and an information stockroom?
How would you copy the content of one repository to another repository?
What does “tail –f” command do and what is its use as an Informatica admin.
what are 3 tech challenges/ common issues you face?
What is Session and Batches?
Design time, run time. If you don't create parameter what will happen
Why filter transformation is an active one?
Partition, what happens if the specified key range is shorter and longer
What are the features of complex mapping?