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
- 27219 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
Explain the code page compatibility?
What is data transformation manager process?
What does reusable transformation mean?
Tell me about Propagate functions in informatica
What does update strategy mean, and what are the different option of it?
Explain load alternative records / rows into multiple targets - informatica
What are the types of data warehouses?
Can we get 1st record through Informatica(without sequence number).
What are the different ways to implement parallel processing in informatica?
What is a standalone command task?
What is olap (on-line analytical processing?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
have u done any performance tuning? how u ll do?
how tokens will generate?
What is the function of union transformation?
