Answer Posted / sree

select sal from emp e where nth=(select count(*) from emp
where sal>e.sal);

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1558

---

Which version configuration tool used in ur project?

2770

---

Explain the different lookup methods used in informatica?

587

---

How do you take back up of repository?

723

---

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

3450

---

---

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

773

---

How does the aggregator transformation handle null values?

699

---

How can you generate reports in informatica?

581

---

What do you understand by a term domain?

670

---

Have you worked with/created Parameter file

1226

---

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

1529

---

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1651

---

How to convert multiple rows to single row (multiple columns) in informatica

895

---

What is target load order?

805

---

What is mapplet in informatica?

596

---