Answer Posted / hanumantharao

Active transformation means recieve n number of records and
return < or > that of n number of records.
Union transformation is Active transformation because it
return less than that of recieved records.

Explain joiner transformation in informatica

1131

---

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2462

---

What do you mean incremental aggregation?

1085

---

What is rank index in rank transformation?

1082

---

Which development components of informatica have the highest usage?

1056

---

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

2041

---

What does command task mean?

1155

---

What is the procedure for creating independent data marts from informatica 7.1?

1068

---

Can we create a Integration service without a Repository service and vice versa?

1217

---

Enlist some properties of sessions.

1087

---

Whats the difference between informatica powercenter server, repositoryserver and repository?

1179

---

What are the different types of olap? Give an example?

1057

---

What is a filter transformation and why it is an active one?

971

---

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

1970

---

How can we handle two sessions in informatica?

1038

---