Interested to Buy Any Domain ? << Click Here >> for more details...
What are the types of lookup caches?
- 10 Answers
- 69014 Views
- Accenture, IBM, Informatica, I also Faced
- E-Mail Answers
Answer Posted / swetha
Persistent cache: yoU can save the lookup cache files and
reuse them the next time the informatica server processes a
lookup transformation configured to use the cache.
Recache from database: If the persistent cache is not
synchronized with he lookup table, yoU can configure the
lookup transformation to rebuild the lookup cache.
Static cache: U can configure a static or readonly cache for
only lookup table. By default informatica server creates a
static cache. It caches the lookup table and lookup values
in the cache for each row that comes into the
transformation. when the lookup condition is true, the
informatica server does not update the cache while it
prosesses the lookup transformation.
Dynamic cache: If you want to cache the target table and
insert new rows into cache and the target, you can create a
look up transformation to use dynamic cache.The informatica
server dynamically inerts data to the target table.
shared cache: yoU can share the lookup cache between
multiple transactions.yoU can share unnamed cache between
transformations inthe same maping.
| Is This Answer Correct ? | 63 Yes | 4 No |
Post New Answer View All Answers
What is confirmed fact in dataware housing?
What is a surrogate key?
How can you generate reports in informatica?
can we override a native sql query within informatica? Where do we do it? How do we do it?
How do you take back up of repository?
What is the need of an ETL tool?
What is a router transformation?
What are the uses of etl tools?
How to improve the performance of a session using sorter transformation?
What are connected or unconnected transformations?
What is lookup 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
Is there any target staging area in informatica not staging area
On which transformations you created partitions in your project?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
