Answer Posted / suresh
lookupT/r is passive tranforamtion where as joiner is active t/r
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
what is the complex transformation you used in informatica
lookup transformation with screenshots
What is union transformation in informatica?
What is the use of target designer?
How to update or delete the rows in a target, which do not have key fields?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What is data caches/ index caches?
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
How an expression transformation differs from aggregator transformation?
Explain the difference between mapping parameter and mapping variable?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Differentiate between reusable transformation and mapplet.
Partition, what happens if the specified key range is shorter and longer
Where is metadata stored?
Define the various join types of joiner transformation?