Answer Posted / chandru

if the date is passed from one active an one passive cannot be connected to the passive transformation the mapping is not valid

but there is a possible way if we have expression(passive) an aggreatror(active) we can connect these active an passive transformation through joiner (active) transformation it is possible

What is workflow manager?

1029

---

Write the different tools in the workflow manager?

1048

---

r u done any partitions in ur project?

1811

---

How to create Target definition for flat files?

1197

---

what are the Methods For Creating Reusable Transformations?

1154

---

What is a difference between complete, stop and abort?

1072

---

How to elaborate powercenter integration service?

1115

---

What do you mean by channel change?

1022

---

What is aggregator transformation in informatica?

925

---

In how many ways we can create ports?

1108

---

What is domain in terms of informatica?

994

---

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

956

---

list out all the transformations which use cache?

1167

---

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

1956

---

wat are deployement groups in informatica, how it will be used for developers

1701

---