how u know when to use a static cache and dynamic cache in
lookup transformation.
- 9 Answers
- 26044 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
What is primary and backup node?
Did u used latest transformations of 8.6.0? for what?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is domain and gateway node?
What is meant by target load plan?
What are connected or unconnected transformations?
What is powercenter on grid?
How does a rank transform differ from aggregator transform functions max and min?
Plz can any one say me how to get the informatica certification materials and dumps
How to update or delete the rows in a target, which do not have key fields?
What are the data movement modes in informatica?
what is mean by complex business rule ?
How do you promote a non-reusable transformation to reusable transformation?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What is expression transformation?
