Interested to Buy Any Domain ? << Click Here >> for more details...
Performance wise which is better joiner or look up ?
Give me with example?
- 1 Answers
- 11284 Views
- CGI, I also Faced
- E-Mail Answers
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
What are roles and groups and benefits of using them?
Explain transaction control transformation in informatica
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Explain load alternative records / rows into multiple targets - informatica
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 steps involved in the migration from older version to newer version of Informatica Server?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
what is the -ve test case in your project.
Define pmcmd command?
What are the types of schemas we have in data warehouse.
How can we use mapping variables in informatica?
How to extract sap data using informatica? What is abap? What are idocs?
Target increases every day even though no new record was inserted
Differentiate between source qualifier and filter transformation?
What is the status code in stored procedure transformation?
