Answer Posted / amedela chandra sekhar

We can't change

Mention few advantages of router transformation over filter transformation.

1069

---

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6282

---

How do you manage the Parameter files while migrating your data from one environment to another environment?

1069

---

Briefly explain the aggregator transformation?

1067

---

What the difference is between a database, a data warehouse and a data mart?

1200

---

What are mapplets? How is it different from a Reusable Transformation?

1136

---

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.

2249

---

What is domain and gateway node?

1206

---

How might you approve all mappings in the archive all the while?

1082

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1956

---

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

2010

---

hi real timers . iam waiting for ur reply regarding ETL TESTING

2312

---

What is workflow? What are the components of the workflow manager?

1171

---

What are the various types of transformation?

1241

---

How would you copy the content of one repository to another repository?

1058

---