Answer Posted / vasu

it will support carry on

can you please explain me pre session and post session options?

7564

---

What are roles and groups and benefits of using them?

1057

---

What is an unconnected transformation?

1087

---

What are the advantages of using informatica as an etl tool over teradata?

1022

---

Explain joiner transformation in informatica

1124

---

What is a filter transformation?

1043

---

What is update strategy transform?

1102

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2199

---

How to generate or load values in to the target table based on a column value using informatica etl tool.

1074

---

Can you generate sequence numbers without using the sequence generator transformation?

1119

---

What are the modules in Power Center

1680

---

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

---

If informatica has its scheduler why using third party scheduler?

1268

---

 Informatica Checkpoints

3330

---

What are the differences between joiner transformation and source qualifier transformation?

1171

---