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
- 27628 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
is it possible to index the data in cache of lkp transformation ?
Write the unconnected lookup syntax?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What is fact table? Explain the different kinds of facts.
Do you find any difficulty while working with flat files as source and target?
How do you take back up of repository?
How do you migrate data from one environment to another?
What is confirmed fact in dataware housing?
What is aggregate cache in aggregator transformation?
wf dont have integration severances how you can run?
if we have a delimiters at unwanted places in a flat file how can we over come those.
Explain sessions. Explain how batches are used to combine executions?
can you please explain me pre session and post session options?
When do you use sql override in a lookup transformation?
What are roles and groups and benefits of using them?
