In Lookup transformation a sql override should be done and
disable
the cache how do you do this procedure?
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
Differentiate between reusable transformation and mapplet.
How to load a Dimension ? and how to load a fact table?
Mention some types of transformation?
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
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Explain where to store informatica rejected data? How to extract the informatica rejected data?
How to differentiate between the active and passive transformations?
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 is meant by incremental aggregation?
What is a repository? And how to add it in an informatica client?
How can we improve session performance in aggregator transformation?
What is the use of code page?
how we can load rejected record's at run time?(not through bad files)
What are the conditions needed to improve the performance of informatica aggregator transformation?
Suppose we do not group by on any ports of the aggregator what will be the output?