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
- 6179 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 |
There are 100 lines in a file. How to print line number 31-50 and 81-90 in unix with a single command.
What is sorter transformation?
What are the transformations that are not supported in mapplet?
if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.
what are the output files that the informatica server creats during running a session?
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?
how to delete duplicate records by using filter transfermation?
What exactly mentioned in High level design document.can somebody explain me sequentialy.
State the limitations where we cannot use joiner in the mapping pipeline?
How to load query faster,so that It will take less time to load?
Does Facttable Normalized or Denormalized?
How do you implement scheduling in Informatica?
Teradata 
