Interested to Buy Any Domain ? << Click Here >> for more details...
What is joiner cache?
- 2 Answers
- 6409 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
When we use the joiner transformation an integration service
maintains the cache, all the records are stored in joiner
cache. Joiner cache have 2 types of cache 1.Index cache 2.
Joiner cache.
Index cache stores all the port values which are
participated in the join condition and data cache have
stored all ports which are not participated in the join
condition.
If it wrong means Please mail me chandranmca2007@gmail.com
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / abhishek
When the Integration Service processes a Joiner transformation, it reads rows from both sources concurrently and builds the index and data cache based on the master rows. The Integration Service then performs the join based on the detail source data and the cache data.
The number of rows the Integration Service stores in the cache depends on the partitioning scheme, the source data, and whether you configure the Joiner transformation for sorted input.
To improve performance for an unsorted Joiner transformation, use the source with fewer rows as the master source. To improve performance for a sorted Joiner transformation, use the source with fewer duplicate key values as the master.
| Is This Answer Correct ? | 0 Yes | 0 No |
expain about the tune parameters?
write asql query to filter improper date format? date 20-apr 11-mar-2010 30-may-2010 feb-2009 i want the output date 11-mar-2010 30-may-2010
What are the issues you have faced in your project? How did you overcome those issues?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What are the types of caches in lookup? Explain them.
I have a scenario like - how can i load 1st record to Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?
how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!
i have one table like cust_id ph1 ph2 ph3 1002 9290123526 97671927210 9876545232 we use Normalizer wt is o/p? sue normalizer we can generate three tables in single table/
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
what are the transformations that are used in data cleansing ? and how data cleansing takes place ?
How can we join the tables if they don't have primary and foreign key relationship and no matching port?
performance wise which one is better in joiner and lookup transformation
Teradata 
