Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different caches used in informatica?
- 3 Answers
- 7224 Views
- UST, I also Faced
- E-Mail Answers
Answer Posted / munireddy
static cache
dynamic cache
shared cache
and persistent cache....
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
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 are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
Is it possible to use a client with different version than that of its Informatica server?
When do you use sql override in a lookup transformation?
define galaxy repository in informatica
Explain the different lookup methods used in informatica?
What is the need of an ETL tool?
What are the conditions needed to improve the performance of informatica aggregator transformation?
Write the advantages of partitioning a session?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Can you use flat files in Mapplets.
Is it possible to define a single node as a Gateway node as well as worker node?
How to load the data from a flat file into the target where the source flat file name changes daily?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
