Answer Posted / chandrasekar
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 |
Post New Answer View All Answers
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How many ways are there to do 'remove duplicate records in informatica'?
What is the difference between stop and abort in informatica
How do you load unique records into one target table and duplicate records into a different target table?
What are the uses of etl tools?
Explain the use of aggregator cache file?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
Quickly characterize reusable change?
Explain how many types of dimensions are available in informatica?
What are data-driven sessions?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What do you mean by worklet?
What is the procedure for creating independent data marts from informatica 7.1?
How do you take back up of repository?
Write the advantages of partitioning a session?