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 |
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is a code page?
What is hash partition?
how lookup is acting as both active and passive ? how is it possitble?
In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?
what is upstream and downstream transformation?
What are the different types of Type2 dimension maping?
What are the two modes of datamovement in informatica sever?
Explain how many types of dimensions are available in informatica?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What is the difference between SOURCE and TARGET BASED COMMITS?
I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?