What is a diff between joiner and lookup transformation

Answer Posted / krishna

I) Joiner is active transformation & lookup is passive
transformation.
2)joiner having input port,output port, master port where as in lookup having input port, output port,lookup port,return port.
3) joiner having sorted inputs option where as lookup doesent have this option

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to Create a folder using pmrep command?

626


What are the advantages of informatica?

576


Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

560


What is domain in terms of informatica?

567


In which transformation you cannot drag ports into it?

795






How to load the data from people soft hrm to people soft erm using informatica?

564


Explain the pipeline partition with real time example?

656


What are the steps involved in the migration from older version to newer version of Informatica Server?

1589


What is a standalone command task?

658


Enterprise data warehouse your projects phase by phase explain?

1473


How many input parameters can exist in an unconnected lookup?

1003


What is the procedure for creating independent data marts from informatica 7.1?

570


waht type of interface is used for testing the data in informatica

1837


How do you handle two sessions in Informatica

669


what is the hint? how to use it to reduce the query processing in program?

6325