Interested to Buy Any Domain ? << Click Here >> for more details...
In Lookup transformation a sql override should be done and
disable
the cache how do you do this procedure?
- 2 Answers
- 8743 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / bprathap4u
Session will be failed with following error message
Message Code: CMN_1254
Message: ERROR: Feature not yet supported: [Lookup override
with caching off]
| Is This Answer Correct ? | 1 Yes | 4 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
permutations of mapplet
r u done any partitions in ur project?
What do you understand by a term domain?
what is the hint? how to use it to reduce the query processing in program?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What are the transformations that are not supported in mapplet?
What is union transformation?
Clarify the utilization of aggregator cache record?
What is rank transformation in informatica
What is meant by incremental aggregation?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What is domain and gateway node?
How can you validate all mappings in the repository simultaneously?
What is the function of look up transformation?
