Answer Posted / narayanaswami

HI FRIENDS........
Please check this answer....
source table has 2 columns id,name.pass to expression .
remove o/p port in name column,take another port select only o/p port, write code in side of the port
REPLACECHR(0,NAME,'NULL',' ')
pass to target. mapping like

SD=>SQ=>EXP=>TGT.

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2398

---

What is the surrogate key?

1263

---

Explain the scenario which compels informatica server to reject files?

1168

---

What is the advantage of informatica?

1069

---

Name the different lookup cache(s)?

1235

---

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

---

What is the reusable transformation?

1047

---

How do you migrate data from one environment to another?

1095

---

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10687

---

What is meant by query override?

1061

---

What does update strategy mean, and what are the different option of it?

1092

---

What you know about transaction control transformation?

996

---

explain abt ur project architecture?

2195

---

wf dont have integration severances how you can run?

1938

---

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1130

---