Answer Posted / pentaho

v can use user define join ........

What do you mean by filter transformation?

938

---

What is the difference between STOP and ABORT options in Workflow Monitor?

1241

---

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

1957

---

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2044

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

2032

---

Can anyone tell me the new features in Informatica 9 Version?

2103

---

Where can we find the throughput option in informatica?

1045

---

How to start a workflow using pmcmd command?

1226

---

What is rank transform?

984

---

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1112

---

Define enterprise data warehousing?

1186

---

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?

1060

---

What is sequence generator transformation in informatica?

1060

---

Explain the difference between a data warehouse and a data mart?

1049

---

Differentiate between joiner and lookup transformation?

1095

---