Answer Posted / vemuri vijay

steps
go to mappings
go to wizards
there is two optins
1.getting started
2.scd
go to scd
again three types
type1
type2
type3
select ur requirement
ex.
take type1
select source table and give name for target table
then
next
give target table fields
then
finish
automatically u will get mapping
go to
workflow manager
create
task and
worklet
start task
thats all

Briefly define reusable transformation?

1077

---

Is stop and abort are same in informatica?

949

---

How does the aggregator transformation handle null values?

1087

---

What is the difference between router and filter?

1156

---

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

1919

---

Differentiate between sessions and batches?

965

---

Scheduling properties,whats the default (sequential)

1896

---

What is event and what are the tasks related to it?

1058

---

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

1015

---

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1807

---

Explain the code page compatibility?

1022

---

In informatics server which files are created during the session rums?

1067

---

What is the difference between informatica 7.0 and 8.0?

954

---

Explain the types of lookup transformation?

980

---

What is a repository manager?

1030

---