Interested to Buy Any Domain ? << Click Here >> for more details...
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
- 4 Answers
- 21433 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / rampriya
Joiner is faster than lookup. Joiner will fetch the data
only once form the database, but the lookup will fetch the
data for each record from the database. So performance wise
joiner is better than lookup.
| Is This Answer Correct ? | 4 Yes | 13 No |
Post New Answer View All Answers
What are data-driven sessions?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Whats the difference between informatica powercenter server, repositoryserver and repository?
Which are the different editions of informatica powercenter that are available?
How we can create indexes after completing the loan process?
Explain the pipeline partition with real time example?
What is the difference between source qualifier transformations source filter to filter transformation?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What is workflow manager?
server hot-ws270 is connect to Repository B. What does it mean?
what is the size of your data warehousing?
How to start a workflow using pmcmd command?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
Where do we use mapping variables in informatica?
