Answer Posted / soujanya
the joiner transformation creates join cache for master
source. from joiner cache the the joiner transformation
compares with detail source.
the joiner cache always uses master source for better
performance bcoz master source has less no. of records.
cache is the temporary memory
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is a predefined event?
Can anyone tell me the new features in Informatica 9 Version?
Can we create two repositories on same database instance in oracle?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Explain your project of banking domian.
How many input parameters can exist in an unconnected lookup?
What is the difference between STOP and ABORT options in Workflow Monitor?
explain about unit testing? in real time?
What is a joiner transformation and why it is an active one?
What is the procedure for creating independent data marts from informatica 7.1?
What is the Process to creating lookup transformation in informatica
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Design a mapping to load a target table with the following values from the above source?
What is meant by lookup transformation?
Write the advantages of partitioning a session?