Answer Posted / santosh kumar sarangi

1.in expression t/r create one more port as below.
FLAG(integer)=IIF(LOWER(COL1)=UPPER(COL1) ,1,0)
2.Link the original port and FLAG port to router and create
a group as FLAG=1
3.Link the original port from the group to target of number
or special charater and default to target of character.

Let me know if any things wrong
Thanks and Regards
Santosh

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

1919

---

What is blocking transformation?

1084

---

Explian the Process of deployment groups in informatica

993

---

Is there any way to read the ms excel datas directly into informatica?

980

---

What is dimensional table?

1004

---

What is flashback table ? Advance thanks

1873

---

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1138

---

What is Data Caches size?

1034

---

Define joiner transformation?

990

---

I have a flat file, want to reverse the contents of the flat file

1068

---

Explain the features of connected and unconnected lookup.

877

---

What is data movement mode in Informatica and difference between them?

1066

---

How can we handle two sessions in informatica?

985

---

what is the size of u r source(like file or table)?

2202

---

What are the designer tools for creating transformations?

1050

---