What is a diff between joiner and lookup transformation

Answer Posted / amit

joiner is active transformation & lookup is passive
transformation

Is This Answer Correct ?    99 Yes 41 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is union transformation in informatica?

701


How does a rank transform differ from aggregator transform functions max and min?

674


can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10280


How do you load unique records into one target table and duplicate records into a different target table?

712


How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

713






Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

742


How do you migrate data from one environment to another?

647


Differentiate between a repository server and a powerhouse?

580


What is rank transformation?

581


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

6480


What is meant by incremental aggregation?

587


Could you explain what is enterprise data warehouse?

556


How big was your fact table

1320


What is data caches/ index caches?

615


IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

564