Do joiner transformation use cache? If so describe?
Answer Posted / mike
Yes joiner transformation has cahches. It joins the data
based on master detail joining condition. It first reads
the master source and stores it in the joiner cache and it
reads the detail source and joins with the data in the
joiner cache based on the master detail joining condition.
correct me if i was wrong
| Is This Answer Correct ? | 17 Yes | 0 No |
Post New Answer View All Answers
Which transformation is needed while using the Cobol sources as source definitions?
How can a transformation be made reusable?
permutations of mapplet
What the difference is between a database, a data warehouse and a data mart?
if we have a delimiters at unwanted places in a flat file how can we over come those.
Briefly describe lookup transformation?
What are roles and groups and benefits of using them?
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.
Differentiate between source qualifier and filter transformation?
What is the way to execute pl/sql script using informatica mapping?
What are the components of the workflow manager?
What is meant by lookup transformation?
How to delete duplicate row using informatica?
What is aggregate cache in aggregator transformation?
Slowly changing dimensions, types and where will you use them