what is the difference between look up and joiner(don't say
joiner sopport only = where as look up support non-equijoin).
- 3 Answers
- 9328 Views
- IBM, ITC Infotech, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kondeti srinivas
with lookup we can do left join only
but with joiner we can do all the joins(normal,master
outer,detail outer,full outer)
for mutiple matching only it will give one return value
based on lookup policy(first value or last value like that)
in lookup transformation. but in the joiner transformation
it will give the output for all the matchings
if any one knows more than this please let me know
| Is This Answer Correct ? | 12 Yes | 1 No |
Answer / akash
In addition to Kondeti's points:
1. With look up we have an option to match the data
dynamically if we use dynamic lookup.
2. If the match is not found may or may not send the record
(depending upon the joiner condition) but in case of look
up the output will be returned as default value or NULL for
every record where match is not found.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / v.ramakrishna
both lookup and joiner transfromations are used to
horizantal merging . But lookup transformation can be
treated as paasive transformation where as joiner trans can
be treated as active transfr bcoz no of records input to
joiner will vary with output records. But in Lookup
transformation even though it searches for each record in
lookup if condition satisfied it will come as output even
condition not satisfied also , in that case it returns null
valu so no of records input to lookup is equal with outputs
due to null values this is the major diff between joiner
and lookup according to me.
| Is This Answer Correct ? | 1 Yes | 0 No |
explain abt ur project architecture?
0 Answers Anthem, DELL, IBM, TCS, Wipro,
What are the connected or unconnected transforamations?
What is joiner change?
how we do performence tuning in informatica
how can u avoid duplicate rows in flat file?
I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution
in static and dynamic which one is better
A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?
How do you set a varible in incremental aggregation
Separate from a database, an information bazaar, and an information stockroom?
Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.
what is normalization? explain 1st NF, 2nd NF, 3rd NF
Teradata 
