Answer Posted / akash
By default caching is not done by informatica, if we want
to use a cache in look up we must set the same in
properties..
Please correct me if I am wrong.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is expression transformation?
Write the prerequisite tasks to achieve the session partition?
what is $$$$?
Which files are created during the session rums by informatics server?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is the difference between informatica 7.0 and 8.0?
What is dimensional table?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What are the advantages of using informatica as an etl tool over teradata?
How union transformation is used?
How to generate or load values in to the target table based on a column value using informatica etl tool.
Explain Dataware house architecture .how data flow from intial to end?
Explain the aggregator transformation?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
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