Interested to Buy Any Domain ? << Click Here >> for more details...
What are the joiner caches?
- 3 Answers
- 17655 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 u explain me banking domain projects ? and in banking domain projects how many dimension tables and how many fact tables and how to load source and targets in mapping level plese expain give me one example?
1 Answers Accenture, Cognizant, HCL, IBM, iGate, L&T, TCS, Virtusa,
write a query row to column follwing source? quarter sales q1 5000 q1 9000 q1 7000 q1 6000 q2 5000 q2 4000 q2 3000 q2 1000 q3 4000 q3 3000 q3 1000 q3 2000 q4 5000 q4 400 i want the output? q1 q2 q3 q4 sales
3 Answers Cognizant, Flextronics,
what is difference between mapping and mapplet ?
Which is the t/r that builts only single cache memory?
Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod(Prod_GRP ,Prod_DT,Prod_TM) ) Like this? Pls explain...
How many repositories can we create in Informatica??
how to sort date field in infomatica?
How can you define user defied event?
what is diff between grep and find
How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????
How You Pull the records on daily basis into your ETL Server.
I have a flat file, want to reverse the contents of the flat file
Teradata 
