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
- 6177 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
need for registering a repository server
Explain load alternative records / rows into multiple targets - informatica
Can you access a repository created in previous version of Informatica?
have u done any performance tuning? how u ll do?
How to load last n records of file into target table - informatica
List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys
Why touse stored procedure in ETL Application?
Hi, source data is col1 values are 5,6,7 col2 are 3,2,1 col3 are 8,9,10 and i want to get target as col1 5,6,7 col2 1,2,3 col3 8,9,10 how to do this one?
What are teh different tasks that can be created in workflow manager?
What if the source is a flat-file?
How to handle changing source file counts in a mapping?
Tell me about informatica architecture.
Teradata 
