Answer Posted / nav

u can use autosys scheduler,or workflow manager in
informatica

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

1082

---

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2353

---

What are the tuning techniques you applied during your last project

1969

---

Design a mapping to load the cumulative sum of salaries of employees into target table?

1424

---

Explain the features of connected and unconnected lookup.

877

---

What are the transformations that are not supported in mapplet?

959

---

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

1918

---

Define Pmrep command?

998

---

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8130

---

What is the procedure for creating independent data marts from informatica 7.1?

1003

---

list out all the transformations which use cache?

1115

---

what is mean by complex business rule ?

2110

---

Explain sessions?

986

---

What is exclusive and normal mode for repository services?

1063

---

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8171

---