how u know when to use a static cache and dynamic cache in
lookup transformation.
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 the sequence generator transformation in informatica?
Separate from a database, an information bazaar, and an information stockroom?
How can you generate reports in informatica?
Where are the source flat files kept before running the session?
list out all the transformations which use cache?
Explain joiner transformation in informatica
What is a repository? And how to add it in an informatica client?
Is it possible to revert a global repository to local one and why?
How can we update a record in the target table without using update strategy?
What is mapplet in informatica?
Why union transformation is an active transformation?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Explain pushdown optimization and types in informatica
What are the different types of transformation available in informatica.
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure