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
- 5599 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 |
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What is the Difference between sorter and aggregator?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
how we can add header and footer to flat files?
2 Answers Tech Mahindra, Zensar,
can v update d records in target using update stargey without generationg primary key ? explain
How to delete duplicate records in a flat file source?
Update strategy transformation is an active transformation.How it changes the number of records that pass through it? Please explain....
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
what is flat file override?
enterprise datawarehouse your project phase by phase explain?
i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))
Name the different lookup cache(s)?
Teradata 
