Interested to Buy Any Domain ? << Click Here >> for more details...
what is the diff b/w cached and unchaed look ups
- 3 Answers
- 7995 Views
- IBM, TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / sunil
when lookup cahing is unabled, informatica server queries
the lookup table once,caches the lookup values during
session.This can inprove session performance.
when u disable lookup caching,each time row pass to the
transformation,informatica server issues an select
statement to lookup table for lookup values
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How do we call shell scripts from informatica?
What are the static cache and dynamic cache in informatica?
What are different types of transformations available in informatica?
Explain informatica architecture - version 8 / 9
Explain the different lookup methods used in informatica?
Differentiate between a database and data warehouse?
What is lookup change?
What is the difference between informatics 7x and 8x and what is latest version?
without table how to come first record only in oracle?
What are the differences between joiner transformation and source qualifier transformation?
What is incremental aggregation?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
which one is better performance wise joiner or look up
Explain load alternative records / rows into multiple targets - informatica
