Interested to Buy Any Domain ? << Click Here >> for more details...
What are the joiner caches?
- 3 Answers
- 17776 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 |
What does command task mean?
What is workflow monitor?
what is the max/min size allocated for caches.whether index or datacache in any of the transformations like Joiner or Aggregator.bcoz it is set to Auto by default which means we need not to allocate no of bytes or MB.so what is the use of these properties.please let me know about the caches. Thnaks in advance Sai Ram
I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.
Write the prerequisite tasks to achieve the session partition?
What is a standalone command task?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
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??
In mapping f.f as one src and f.f as trg,f.f as src and oracle as trg which is fast? mean which is complete first process
I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?
Hello...... How can i set my mapping as read-only? Please answer me. Advance thanks
What is enterprise data warehousing?
Teradata 
