How can a Lookup with Dynamic Cache be replaced in a
mapping? Explain.
Answer Posted / abhishek.x.upadhyay
A lookup with Dynamic cache can be replaced by an SQL
override query in the transformation itself which will run
each time there is load of data during the run of the
Workflow.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
Where can we find the throughput option in informatica?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
How to generate sequence numbers using expression transformation?
What are the uses of etl tools?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Whats there in global repository
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What do you mean by channel change?
What are the types of schemas we have in data warehouse.
Explain how to import oracle sequence into informatica?
What is decode in static cache?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Define update strategy?
Does an informatica transformation support only aggregate expressions?