Interested to Buy Any Domain ? << Click Here >> for more details...
what is the diff b/w cached and unchaed look ups
- 3 Answers
- 7829 Views
- IBM, TCS, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mike
well
Cached Lookup: In a lookup cache the entire rows will be
put in the buffer and then will be compared with the in
coming rows
where as
uncached lookup: In the uncahed lookup for every row the
lookup will query the lookup table to get the rows
correct me if i was wrong
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / 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 |
Answer / sujana
if v cache the lukup..IS queries the cache for each row dat
eneters
if v dont cache IS queries the database for each row dat
enters..i.e issues a slect statemnt for each row
| Is This Answer Correct ? | 3 Yes | 1 No |
how will compare two mappings in two different repository?
How to Create a folder using pmrep command?
update strategy transformation in informatica
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
How to differentiate between the active and passive transformations?
How to delete duplicate record in Informatica?
how many types of dimensions are available in informatica?
Can anyone tell me the new features in Informatica 9 Version?
Can a joiner be used in a mapplet.
I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?
What are set operators in Oracle
Design time, run time. If you don't create parameter what will happen
Teradata 
