Interested to Buy Any Domain ? << Click Here >> for more details...
what is the diff b/w cached and unchaed look ups
- 3 Answers
- 7699 Views
- IBM, TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Have you worked with/created Parameter file
What is the difference between a connected look up and unconnected lookup?
What is Data Caches size?
Mention few advantages of router transformation over filter transformation.
Which is the t/r that builts only single cache memory?
what is the size of u r source(like file or table)?
Mention some types of transformation?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What is a passive transformation?
What is parallel processing in informatica?
what is size of u r database?
What is the function of union transformation?
What does cheating measurement mean?
