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
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
have u done any performance tuning? how u ll do?
what is the Default Source Option For Update Strategy Transformation?
What is meant by lookup transformation? Explain the types of lookup transformation?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What is the command used to run a batch?
How to extract sap data using informatica?
design of staging area?
In how many ways we can create ports?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
Enlist some properties of sessions.
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
How do you update the records with or without using update strategy?
What are data-driven sessions?