Interested to Buy Any Domain ? << Click Here >> for more details...
What are the joiner caches?
- 3 Answers
- 17601 Views
- Informatica, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swetha
When a Joiner transformation occurs in a session, the
Informatica Server reads all the records from the master
source and builds index and data caches based on the master
rows.After building the caches, the Joiner transformation
reads records from the detail source and perform joins.
| Is This Answer Correct ? | 16 Yes | 1 No |
Answer / atiric sofrware(raja)
joiner caches are data cache and index cache data cache.
data cache that holds the master table rows and the index
cache which holds the join columns from the master table
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / 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 |
How does a sorter cache works?
what is incremantal aggregation?
There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session??
pmscmd startworkflow -sv <host name> -d <domain name> -u <user name> -p <password> -f <folder name> <workflow name> while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?
Howmany ways yoU can update a relational source defintion and what are they?
Explain joiner transformation in informatica
Enlist the differences between database and data warehouse.
What are the types of maping in Getting Started Wizard?
what is fact table?
What are the different types of repositories created using informatica?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Differentiate between mapping parameter and mapping variable?
Teradata 
