Answer Posted / ganesh kamble

We can clearly understand that we need a Router transformation to route or filter source data to the three target tables. Now the question is what will be the filter conditions.

First of all we need an Expression Transformation where we have all the source table columns and along with that we have another i/o port say seq_num, which gets sequence numbers for each source row from the port NEXTVAL of a Sequence Generator start value 0 and increment by 1.

Now the filter condition for the three router groups will be:
MOD(SEQ_NUM,3)=1 connected to 1st target table MOD(SEQ_NUM,3)=2 connected to 2nd target table MOD(SEQ_NUM,3)=0 connected to 3rd target table

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1688

---

What is native users?

1167

---

What is target designer and target load order?

1108

---

Under what conditions selecting sorted input in aggregator will still not boost session performance?

1080

---

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

---

Do you find any difficulty while working with flat files as source and target?

1098

---

Whats there in global repository

1696

---

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8223

---

What is domain in terms of informatica?

1007

---

list out all the transformations which use cache?

1184

---

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2520

---

How to elaborate powercenter integration service?

1136

---

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7454

---

What is the surrogate key?

1264

---

Scheduling properties,whats the default (sequential)

1956

---