Interested to Buy Any Domain ? << Click Here >> for more details...
how u know when to use a static cache and dynamic cache in
lookup transformation.
- 9 Answers
- 27947 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / hari
By default lookup is static.
Dynamic is used whn the records coming frm the source to
target in multiple times. i.e if
1)
emp_id=101...city=hyd...age=25...
(first this is inserted to target)
2)at second time when 101 employee is changing his city frm
hyd to chennai here we need to update the target table with
city name as chennai. thn how lookup cache knows tht a
record is updated...
3) if it is static lookup, after updating tht record it
will not refresh the lookup cache.... where as if it is
dynamic cache it will refresh the cache....
4) Based on our requirement we r going to use.....
| Is This Answer Correct ? | 15 Yes | 1 No |
Post New Answer View All Answers
Differences between connected and unconnected lookup?
What is Data Caches size?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Mention few power centre client applications with their basic purpose?
What is target designer and target load order?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is meant by incremental aggregation?
Under what condition selecting sorted input in aggregator may fail the session?
What does “tail –f” command do and what is its use as an Informatica admin.
How to convert multiple rows to single row (multiple columns) in informatica
can we override a native sql query within informatica? How do we do it?
Whats the difference between informatica powercenter server, repositoryserver and repository?
Write the unconnected lookup syntax and how to return more than one column.
what is Active lock explain
Suppose we do not group by on any ports of the aggregator what will be the output?
