Answer Posted / ande

there are three types SCD:
type-1: in this we can over write original recourd with new
record
type-2: we can create new record
type-3: we can create new attribute
regards,
ande

Define mapplet?

1016

---

Explain in detail about scd type 1 through mapping.

1555

---

As union transformation gives UNION ALL output, how you will get the UNION output?

1109

---

Explain joiner transformation in informatica

1128

---

Write the unconnected lookup syntax and how to return more than one column.

1112

---

Partition, what happens if the specified key range is shorter and longer

2500

---

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

---

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

1122

---

Sequence generator, when you move from develoment to production how will you reset

2043

---

Define enterprise data warehousing?

1208

---

What is data transformation manager process?

1166

---

Explain how to import oracle sequence into informatica?

1020

---

How you can differentiate between connected lookup and unconnected lookup?

1064

---

How to generate or load values in to the target table based on a column value using informatica etl tool.

1080

---

What is joiner transformation in informatica?

1046

---