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
- 5601 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
In warehouses how many schemas are there?
What do you understand by term role-playing dimension?
What is meant by LDAP users?
What is aggregate cache in aggregator transformation?
How would you join a node to the already existing domain?
How to create or import flat file definition in to the warehouse designer?
What is a node in Informatica?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Write the program through which the records can be updated?
What is rank transform?
what is the -ve test case in your project.
What is DR strategy for Informatica project?
What is flashback table ? Advance thanks
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
How to create a non-reusable instance of reusable transformations?
