Answer Posted / amedela chandra sekhar

If you are using groupby the integration service produces
one row for each group, if you do not use groupby the
integration service returns one row(last row) for all input
rows.







chandumba2005@gmail.com

How can we remove the duplicates from flat file source?

948

---

Explain load alternative records / rows into multiple targets - informatica

1099

---

What are multi-group transformations?

1011

---

The question was on time stamp. what is the difference between HH and HH24 when to use when.

1994

---

What is a surrogate key?

1016

---

How to create Target definition for flat files?

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

1918

---

How can we create index after completion of load process?

1071

---

In how many ways we can create ports?

1067

---

Explain the pipeline partition with real time example?

1083

---

Differentiate between reusable transformation and mapplet.

1028

---

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2053

---

What do you understand by term role-playing dimension?

982

---

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1089

---

permutations of mapplet

2454

---