Answer Posted / mehul thakur

Hi sravanti
Could U please explain how to join ?

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

1804

---

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1132

---

Which are the different editions of informatica powercenter that are available?

971

---

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

964

---

What is meant by query override?

1004

---

How to generate sequence numbers using expression transformation?

1025

---

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

910

---

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

---

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2178

---

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?

997

---

What is the session task and command task?

987

---

Explian the Process of deployment groups in informatica

989

---

What is an Integration service in Informatica?

1080

---

What is the cumulative sum and moving sum?

1134

---

Differentiate between joiner and lookup transformation?

1046

---