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
Can we create a Integration service without a Repository service and vice versa?
How to elaborate tracing level?
Global and Local shortcuts. Advantages.
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is meant by a domain?
How can we delete duplicate rows from flat files?
Briefly define reusable transformation?
How to differentiate between the active and passive transformations?
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
What is a pre-defined event and user-defined event?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What differs when we choose the sorted input for aggregator transformation?
wat are deployement groups in informatica, how it will be used for developers
How do you load only null records into target?
