Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 2 Answers
- 6350 Views
- TCS, I also Faced
- E-Mail Answers
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
Define Pmrep command?
Differentiate between reusable transformation and mapplet.
What is meant by a domain?
Enterprise data warehouse your projects phase by phase explain?
What is an expression transformation in informatica?
What is session task and command task?
What is the sequence generator transformation in informatica?
Define pmcmd command?
What is the function of aggregator transformation?
What is a rank transform?
What are the differences between a connected lookup and unconnected lookup?
Enlist the tasks for which source qualifier transformation is used.
What are Dimensional table?
How many dimensions are there in informatica?
lookup transformation with screenshots
