Answer Posted / 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 |
Post New Answer View All Answers
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Which development components of informatica have the highest usage?
what are the Methods For Creating Reusable Transformations?
How to start a workflow using pmcmd command?
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
What are the tasks that source qualifier perform?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Write the prerequisite tasks to achieve the session partition?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
update strategy transformation in informatica
Explain the types of transformations?
Define sessions in informatica etl?
What are the different types of repositories created using informatica?
Explain why we use partitioning the session in informatica?
What is primary and backup node?
