Interested to Buy Any Domain ? << Click Here >> for more details...
What are the joiner caches?
- 3 Answers
- 17592 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 |
Can we get 1st record through Informatica(without sequence number).
how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy
What is powercenter on grid?
What is aggregate awareness?
can we use bulk loading when we use look in mapping
Howmany ways yoU can update a relational source defintion and what are they?
How u use pdf file in informatica source?
How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
Did u used latest transformations of 8.6.0? for what?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
without using emailtask how will send a mail from informatica?
What are the tasks that can be performed using sq?
Teradata 
