Answer Posted / kalyan

In SQL override (Source Qualifier level) write a query to
join the 2 tables like emp & dept as follows:

Select * from emp,dept;

The above query will return the cartesian product of the 2
tables; BTW, this don't have any condition...

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

---

What is complex mapping?

1125

---

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

2128

---

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2136

---

What do you mean by channel change?

1051

---

Why update strategy and union transformations are active?

1046

---

How to use pmcmd utility command?

1038

---

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2400

---

Differentiate between joiner and lookup transformation?

1102

---

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2361

---

What are the components of Informatica? And what is the purpose of each?

1055

---

Write the program through which the records can be updated?

1007

---

In informatica workflow manager, how many repositories can be created?

1363

---

Scheduling properties,whats the default (sequential)

1959

---

What is the Process to creating lookup transformation in informatica

1046

---