Answer Posted / harman dhaliwal

Hi
This is Harman Dhaliwal.
Informatica trainer.
Contact me at harman@whitec0de.com for any kind of training
on INFA

Regards,
Darman D

What is the difference between a connected look up and unconnected lookup?

967

---

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

1127

---

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 are batches?

1101

---

What are mapplets?

1274

---

Performance tuning in UNIX for informatica mappings?

2568

---

Is it possible to create multiple domains on a single Informatica server?

1243

---

can u give example for factless fact table

6651

---

Separate from a database, an information bazaar, and an information stockroom?

1089

---

Under which circumstances, informatica server creates reject files?

1096

---

Explain pushdown optimization $pushdownconfig parameter - informatica

1147

---

What is the use of code page?

1096

---

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1069

---

How to use pmcmd utility command?

1034

---

What is informatica?

1156

---