Answer Posted / nidhi

yes,Using stored procedure t/r we can do that..

I can give u brief idea.. i didnt tried this, sorry if it
goes wrong..

while writing the SP in oracle,we will call n execute the
existing sequence using execute immediate clause..
The o/p port of the SP t/r will be mapped to the sequence no
column in the target.


If i am wrong let me knw.. Thank you

What do you mean incremental aggregation?

1086

---

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

1972

---

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2169

---

What is domain in terms of informatica?

1012

---

What are the types of data warehouses?

1528

---

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

1132

---

Explain how many types of dimensions are available in informatica?

1107

---

What are the components of the workflow manager?

1143

---

what are the deliverables?in your project?

2155

---

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1093

---

How will the document be delivered to me?

1090

---

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2128

---

What is the Rank index port in Rank transformation?

1066

---

What is resilience time?

1156

---

What are the features of complex mapping?

1167

---