Answer Posted / chandrasekhar

You need to use MOD function based on you can filter it
out.. then you will get 1..10..20..30....like we will get it

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

852

---

How are the sources and targets definitions imported in informatica designer?

883

---

Explain transaction control transformation in informatica

1047

---

What is the difference between writing a joiner query in ANSI style and THETA style?

2150

---

Differences between version 7.x and 8.x.

1658

---

Describe the impact of several join conditions and join order in a joiner transformation?

851

---

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1362

---

Differentiate between a repository server and a powerhouse?

803

---

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

1747

---

What are the types of lookup transformation?

861

---

What is confirmed fact in dataware housing?

6255

---

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

899

---

4 yrs etl devloper roles and responsibilities?any body give solutions

1861

---

What are the various types of transformation?

903

---

what is unit testing?tell me proceedure

1999

---