what is the diff b/w cached and unchaed look ups
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
Scheduling properties,whats the default (sequential)
How do we call shell scripts from informatica?
What is a standalone command task?
what is the size of u r source(like file or table)?
What is source qualifier transformation in informatica?
What do you mean by channel change?
Differentiate between a repository server and a powerhouse?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Can anyone tell me the new features in Informatica 9 Version?
What is the maplet?
What is decode in informatica?
What is rank transformation in informatica
what are 3 tech challenges/ common issues you face?
What is a transaction control transformation?
Sequence generator, when you move from develoment to production how will you reset