what is the difference between look up and joiner(don't say
joiner sopport only = where as look up support non-equijoin).
- 3 Answers
- 9325 Views
- IBM, ITC Infotech, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the different transaction levels available in transaction control transformation?
On which transformations you created partitions in your project?
what is diff b/t sorter t/r and agg have the option sorter property...
How can informatica be used for an organization?
What are mapplets? How is it different from a Reusable Transformation?
How do you load only null records into target?
How to elaborate powercenter integration service?
What are Dimensional table?
What is sq transformation?
What is meant by query override?
Explain in detail scd type 2 through mapping.
What is the session task and command task?
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?
Under what condition selecting sorted input in aggregator may fail the session?
What are ETL Tools?
