What is a diff between joiner and lookup transformation
Answer Posted / kalpana
joiner doesnt support nonequi joins where as lookup support
nonequijoin
| Is This Answer Correct ? | 72 Yes | 12 No |
Post New Answer View All Answers
What is complex mapping?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What are multi-group transformations?
How to partition the Session?
What is target designer and target load order?
What is Data Caches size?
What is the advantage of informatica?
How to convert multiple rows to single row (multiple columns) in informatica
Explain what are the different types of transformation available in informatica.
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
Whats the difference between informatica powercenter server, repositoryserver and repository?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Enlist the various types of transformations.
Is it possible to use a client with different version than that of its Informatica server?