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
- 5824 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 |
Can we write to_date(three arguments) ? Will it work ? Advance thanks
How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)
what are the reusable tasks in informatica ?
11 Answers CTS, HP, IBM, TCS,
What is Performance tuning in Informatica?
What is difference between a gateway node and worker node?
If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?
In which scenario did you used pushdown optimization?
what is a transforamation?
we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?
can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?
Teradata 
