Performance wise which is better joiner or look up ?
Give me with example?
Answer Posted / abhinaw prakash
There is no definite answer to this.But if we are using
homogenous data sources its better to use Look up rather
than joiner.
Again Look up can only perform left outer join.So for other
Join we have to use Joiner.
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
How to use pmcmd utility command?
difference between repository database and repository service?
What is the difference between Active and Passive transformation?
Plz can any one say me how to get the informatica certification materials and dumps
Can you use flat files in Mapplets.
What is the way to execute pl/sql script using informatica mapping?
How do you set a varible in incremental aggregation
Target increases every day even though no new record was inserted
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.
Design a mapping to load the cumulative sum of salaries of employees into target table?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
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
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What are the designer tools for creating transformations?
What is event and what are the tasks related to it?