1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

what is the diff b/w cached and unchaed look ups

Question Posted / guest

Answers were Sorted based on User's Feedback



what is the diff b/w cached and unchaed look ups..

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

what is the diff b/w cached and unchaed look ups..

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

what is the diff b/w cached and unchaed look ups..

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

Post New Answer

More Informatica Interview Questions

Design a mapping to get year of join for each employee.

4 Answers   Accenture,

What is an expression transformation?

0 Answers  

What is a configuration management?

1 Answers  

I have id, seq_no date, bill_amt and weight 1,11,'01-Jan-2014',100,2 2,12,'01-Jan-2014',40,5 3,13,'01-Jan-2014',32,5 4,14,'01-Jan-2014',98,2 5,15,'01-Jan-2014',105,3 6,16,'01-Jan-2014',11,3 1,11,'02-Jan-2014',40,2 2,12,'02-Jan-2014',100,5 3,13,'02-Jan-2014',132,5 4,14,'02-Jan-2014',198,2 5,15,'02-Jan-2014',15,3 6,16,'02-Jan-2014',16,3 Now I need output as date MXAMT_LSTWGHT MINAMT_GRTWGHT 01-Jan-2014 100 32 02-Jan-2014 198 100 Could not think of mapping to do so. Please help

1 Answers   Axtria,

what is the size of ur database(like oracle)

2 Answers   HP,




What are the different options used to configure the sequential batches?

2 Answers   Wipro,

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))

5 Answers   Cap Gemini,

What is joiner transformation in informatica?

0 Answers  

Can anyone tell me the new features in Informatica 9 Version?

2 Answers   Syntel,

How to retrieve last two days updated records?

4 Answers  

How can one identify whether mapping is correct or not without connecting session?

0 Answers  

What is Session and Batches?

0 Answers   Informatica,

For more Informatica Interview Questions Click Here
Categories