Answer Posted / rajesh myle
1. Lookup T/R supports Non-Equi Joins. Where as Joiner
T/R does not support the Non Equi Joins. (Joiner T/R
supports only Equi Joins(i.e. ‘=’))
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
In warehouses how many schemas are there?
What is primary and backup node?
Briefly explain the aggregator transformation?
Does an informatica transformation support only aggregate expressions?
How to elaborate tracing level?
What is difference between a gateway node and worker node?
Different qualification between a related rotate toward the sky and isolates look upward?
What are the components of the workflow manager?
What is the Process to creating lookup transformation in informatica
Is it possible to use a client with different version than that of its Informatica server?
How to join three sources using joiner?
Difference between Data and Index Caches?
State the limitations where we cannot use joiner in the mapping pipeline?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure