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
- 10271 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
list out all the transformations which use cache?
What is source qualifier transformation in informatica?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Why filter transformation is an active one?
Describe data concatenation?
What are the performance considerations when working with aggregator transformation?
How do you take back up of repository?
How to open an older version of an object in the workspace?
What is the reusable transformation?
rank() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid order by case when opt2.dm_market_flg in ('Y', 'U') then 1 else 2 end, lkp.contact_rank) as rank1, case opt2.contact_type when 'Buyer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, ship_to_flg desc , last_order_dt desc) when 'Decision Maker' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc , last_quote_dt desc , mailability_score desc , source_ranking desc) when 'Influencer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) when 'Payer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) --elu 05/28/2013 else row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) end rank2 row_number() over (partition by opt3.dim_plat_site_id, opt3.dim_site_opt_sid order by rank1,rank2) as "rank", case when "rank"<= opt3.maximum_value then 'Y' else 'N' end as include_flg
Scheduling properties,whats the default (sequential)
Where is metadata stored?
How do you handle two sessions in Informatica
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
