Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between look up and joiner(don't say
joiner sopport only = where as look up support non-equijoin).
- 3 Answers
- 10397 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 |
If we are using an aggregator but forget to mention the group by port .what will be the output??
Explain the scenario which compels informatica server to reject files?
What is the scenario which compels informatica server to reject files?
What are the types of groups in Router transformation?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
8.what is mapplet ?give example?
1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records, the session got failed. how do u load the rest of records ?? 3) use of lookup override
how to declare array in plsql?
I've an excel sheet, in which one column contains data about the location like "City, State" and few columns contains only "State". Now I wanna load into my target City and State into two different columns. Pls help me out...
What are the conditions needed to improve the performance of informatica aggregator transformation?
Hi, What is exactly node ? what is exactly domain ? How loadbalancer will work ? what is Integration service (IS) ? Can anyone give me exact scenario when I click on start workflow in the workflow manager ? (Note : I am not expecting answer like, node means logical representation of a machine and domain will contain multiple nodes .I gone through Informatica help but I couldn’t understand. I am expecting exactly what is happening in background detailed explanation or Pictorial representation will be highly appreciation ) Advance thanks
How can you change from reusable session into non-reusable session.
Teradata 
