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 decode in static cache?
What are the settings that you use to configure the joiner transformation?
In warehouses how many schemas are there?
What are the steps involved in the migration from older version to newer version of Informatica Server?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What are the differences between a connected lookup and unconnected lookup?
What is the function of union transformation?
how we can load rejected record's at run time?(not through bad files)
How can you define user defied event?
How do you convert single row from source into three rows into target?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Differentiate between sessions and batches?
State the limitations where we cannot use joiner in the mapping pipeline?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Where do we use mapping variables in informatica?