Answer Posted / sruthi

Totally 10 tasks are there
1)COMMAND
2)ASSIGNMENT
3)SESSION
4)LINK TASK
5)EMAIL
6)CONTROL
7)DECISION
8)EVENT WAIT
9)EVENT RAISE
10)TIMER

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

1967

---

Explain dynamic target flat file name generation in informatica

1045

---

During the running session, output files are created by informatica server. Enlist few of them.

976

---

What is a dimensional model?

977

---

Explain lookup transformation is active in informatica

1088

---

What is sq transformation?

1156

---

What do think which one is the better joiner or look up?

1201

---

Explain the tuning lookup transformation - informatica

988

---

what is Active lock explain

2793

---

To import the flat file definition into the designer where should the flat file be placed?

1057

---

What is data caches/ index caches?

1097

---

What is a transaction control transformation?

1204

---

What is the format of informatica objects in a repository?

1016

---

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

2119

---

What is the session task and command task?

1052

---