Answer Posted / harleen

The question needs to be corrected.I think there are 3 rows already in the target and only one row has to be inserted.
The same can be done by 2 ways

1)Update strategy (Update as Insert)

2)Dynamic lookup

How do you load only null records into target?

742

---

What is an expression transformation?

592

---

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1558

---

Explain lookup transformation is active in informatica

662

---

Write the program through which the records can be updated?

516

---

---

Can we change Dynamic to Static or Persistent cache? If so what happens?

1728

---

Which transformation is needed while using the Cobol sources as source definitions?

727

---

Define update strategy?

637

---

How do you load only null records into target? Explain through mapping flow.

1507

---

What is union transformation?

575

---

complex mapping ur project u r invlve can u explain and give real time example give me ?

1840

---

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

1528

---

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1062

---

What is resilience time?

655

---

What is dimensional table?

621

---