which is better perfomancewise lookup or joiner and why?can anyone give example?
Answer Posted / m.m.basha
performwise both (connected& unconnected) are best
connected lookup :-it is connected to the source
unconnected loockup:- it is not connected to the source
| Is This Answer Correct ? | 1 Yes | 12 No |
Post New Answer View All Answers
Have you worked with/created Parameter file
What is the difference between informatica 7.0 and 8.0?
Write the program through which the records can be updated?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
write a query to retrieve the latest records from the table sorted by version(scd)
How does a rank transform differ from aggregator transform functions max and min?
What is meant by active and passive transformation?
What is the meaning of up gradation of repository?
How many dimensions are there in informatica?
In informatics server which files are created during the session rums?
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
Explain lookup transformation is active in informatica
What are the types of lookup transformation?
What is event and what are the tasks related to it?
What if the source is a flat-file?