What is a diff between joiner and lookup transformation
Answers were Sorted based on User's Feedback
Answer / prasanna
Joiner is active transformation in informatica to merge
nonsimilar structures into target warehouse systems.
Joiner needs a condiotion for data merging based on
following types
1.Normal join
2.Maste outer join
3.Detail outer join
4.Full outer join
Lookup is a passive transormation in informatica.this
transformation is used for data verfications of the source
table in assign lookup table
Lookup needs a condition if the condition is satisfied
returns corresponding data else returns null value.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / shiva shankar naidu n
1.Join supports all types of joins, but lookup supports only
two types of joins supports like inner and left outer only..
2.join not provided rejected link, but lookup provided it.
3.join is high sorting speed but not lookup.
4.join takes huge amount of data from two tables, but look
up not supported to data than source table.
5.In lookup Reference data always less than source data
other wise its not suppoted.
6.lookup always based on condition, but not join stage.
7.join common column must be same, in look up no need common
column name.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / kittu
hi every one
i read all the answers i agree with you but one more thing is there in joiner. once u specify d joiner it will extract all the data from source and check the based on condition then it returns values.
in look up it wont take any values but it refers based on condition.It means look up check the values present r not.
here main thing is memory if cache size is increase it decrease the informatica performance.same thing will happen in joiner trans so mostly we r not using joiner but some times based on source data we use.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
Answer / shiva
Joiner transformation:
it has its own cache.
look up transformation:
it maintains its own cache
Is This Answer Correct ? | 21 Yes | 23 No |
Answer / guest
If you are not a performance geek, somewhat basic things
you can do with both joiner and lookup t/f. However Joiner
operates on sources where as lookup operates source as well
as target. there are other things can also be identified as
limitation of working with heterogenious sources in both
the case.(can lookup work on xml file?)
Is This Answer Correct ? | 7 Yes | 19 No |
Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio
Performance tuning in UNIX for informatica mappings?
In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?
What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.
Design a mapping to calculate department wise sum of salaries and load it in single target? Source Target Deptno Salary Deptno Salary 10 100 10 600 10 200 10 600 10 300 10 600 20 200 20 800 20 300 20 800 20 300 20 800 30 400 20 1500 30 500 30 1500 30 600 30 1500
why union is active transformation?
How to delete duplicate row using informatica?
How can we use mapping variables in informatica? Where do we use them?
What are slowly changing dimensions?
5 Answers Informatica, Verinon Technology Solutions,
How do you implement unconn. Stored proc. In a mapping?
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.
What is difference macros and prompts?