what is lookup chache?
Answer / mike
The informatica server builds a cache in the memory when it
process the first row of a cached lookup transformation.It
allocates the memory based on the amount you configure in
the trandformation or session properties.The informatica
server stores the conditional values in the index cache and
data values in the data cache..
correct me if i was wrong
| Is This Answer Correct ? | 3 Yes | 0 No |
What is the difference between a shortcut of an object and copy of an object? Compare them.
i have one senario i have table with 2columns one for primary key another is a constant value(zero). i have to lookup the table and get the maximum primary key here i don't have any common column between source and lookup table(wt table i explained above)... table is (i am assuming he didn't give the table) column1 column2 5 0 2 0 8 0 6 0 3 0 12 0 7 0
Performance tuning in UNIX for informatica mappings?
What is the difference between normal and bulk loading? Which one is recommended?
Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj
How can we update a record in the target table without using update strategy?
Can anyone guide me the steps to install informatica PC 8.5.1 with database as oracle
What are the new features of informatica 9.x at the developer level?
How would you copy the content of one repository to another repository?
what is materialized view?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
How to load data into 3 target tables which are in different schema but with the same name and same relational connection at infromatica level ? How to differentiate while loading ? and how to load ?