what is shared lookup&persistent lookup?
Answer Posted / santoshkumar chakka
I know abt 4 types lookup's
they are
1.static lookup
2.dynamic lookup
3.persistence lookup
5.No Cache lookup
PERSISTENCE LOOKUP:By default .dat and .idx files are created using session execution time and these are deleted automatically at the end of session execution using persistence property the cache files are not deleted even after session execution.the same cache files are uesed for next exicution
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Differentiate between a database and data warehouse?
Is there any target staging area in informatica not staging area
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
How to extract sap data using informatica? What is abap? What are idocs?
How to load the data from a flat file into the target where the source flat file name changes daily?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is Index Caches size?
What is workflow? What are the components of workflow manager?
What is data transformation manager process?
Is it possible to revert a global repository to local one and why?
What is the status code in stored procedure transformation?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
In what scenario we use to improve session performance by pushdown optimization?can any one give example?