Using Connected or unconnected lookup for performance wise which one is preferable?.
- 1 Answers
- 2280 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer / sam
Performance wise unconnected lookup transformation is better as it returns one port & does not build dynamic cache. only static cache is build .
| Is This Answer Correct ? | 0 Yes | 0 No |
in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?
How would you copy the content of one repository to another repository?
Can we use unconnected lookup as dynamic lookup?
5 Answers ITC Infotech, TCS, Wipro,
Informatica and datawarehousing courses in Pune?
Explain the difference between a data warehouse and a data mart?
How you prepared reports for OLAP?
what is parameter file?
When do you use mapping parameters? (In which transformations)
How does the aggregator transformation handle null values?
Tell me one complex query in oracle ?
in realtime which situations u can use unconnected lookup transformation
What is an Integration service in Informatica?
Teradata 
