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
- 10087 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
How to create Target definition for flat files?
have u done any performance tuning? how u ll do?
Explain the aggregator transformation?
Differentiate between sessions and batches?
What is lookup transformation?
Differentiate between joiner and lookup transformation?
can we override a native sql query within informatica? Where do we do it?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is sequence generator transformation in informatica?
Explain target update override in informatica
How is union transformation utilized?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
explan ur project architecture?
What is informatica worklet?
