When do we use dynamic cache and static cache in connected
and unconnected lookup transformations?
- 3 Answers
- 11980 Views
- I also Faced
- E-Mail Answers
Answer Posted / bc
we can use dynamic and static cache in connected
lookup..and we can use only static cache in unconnected
lookup.
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
Differentiate between a repository server and a powerhouse?
how we can load rejected record's at run time?(not through bad files)
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
can u give example for factless fact table
What are the tuning techniques you applied during your last project
How to configure mapping in informatica?
Scheduling properties,whats the default (sequential)
What is the difference between a connected look up and unconnected lookup?
What is difference between a gateway node and worker node?
What is joiner change?
expain about the tune parameters?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What is rank transformation?
