How can a Lookup with Dynamic Cache be replaced in a
mapping? Explain.
Answers were Sorted based on User's Feedback
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 |
Answer / qamar
I suppose the answer to this question is by using Joiner
transformation.
| Is This Answer Correct ? | 1 Yes | 0 No |
1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
if we are extracting 600000 records from a source table so how much volume of records frequently we load in warehouse. (Iknow its depend on client requirement) still i want to know how much volume of records store in warehouse.
Whats the difference between $, $$, $$$
Explain transaction control transformation in informatica
What are pre and post-session shell commands?
which one is better either active or passive transformation in informatica
Why update strategy and union transformations are active? Explain with examples.
Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u
SO many times i saw "$PM parser error " .what is meant by PM?
What does role playing dimension mean?
How will you combine 3 different sources with a single source?