Answer / rao

How can you join 3 heterogeneous sources to a single source
qualifier?.
For this you need to use 2 joiner transformations and the
resulted cloumns can be connected to the target.

Answer / veeru

No,

By joining the three sources, we can load in to the target

how can we load first and last record from a flat file source to target?

7 Answers   Infosys, ITC Infotech,

---

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

0 Answers  

---

Explain one complecated mapping?

3 Answers   Fidelity, Wipro,

---

Is it possible to revert a global repository to local one and why?

0 Answers  

---

how can u tune u r informatica mapppings

2 Answers   CTS,

---

As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this in mind: If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation. May i know the reason behind this?

2 Answers  

---

what are the types of Data warehousing ?

1 Answers  

---

In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?

6 Answers   IBM,

---

How the Informatica Server reads perameter file?

1 Answers  

---

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

0 Answers  

---

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

0 Answers  

---

Can anyone please help me out,In which transformations records will be rejected and how capture those records?and How to reload the rejected records?

3 Answers   Syntel,

---