Interested to Buy Any Domain ? << Click Here >> for more details...
what is the diff b/w cached and unchaed look ups
- 3 Answers
- 7881 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 |
What is confirmed dimension with scenario
What do you mean by channel change?
what is the drillup & drill down?and use of the drill up and drill down?
how do u use sequence created in oracle in informatica? Explain with an simple example
What happens if the info. Server doesn't find the session parameter in the parameter file?
In ur current projectu have done any performance tuning of mappings?
what is the difference between static and dynamic
what are the limitation of sorter transformation?
I have a file with data comming as 1,x1,x2,x3 2,a1,a2 3,b1,b2,b3,b4 1,y1,y2,y3 2,c1,c2,c3 3,d1,d2 my out put should be as follows x1,x2,x3,a1,a2,<null>,b1,b2,b3,b4 y1,y2,y3,c1,c2,c3,d1,d2,<null> Please let me know how can we acheive this in informatica Thanks in advance
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
1:when we develop a project what are the performance issue will raise?? KPIT 2:if a table have INDEX and CONSTRAINT why it raise the performance issue bcoz when we drop the index and disable the constraint it performed better??KPIT 3:what are unix commands frequently used in informatica??
What is the surrogate key?
Teradata 
