Answer / infa_geek

Integration Service follows instructions coded into Update
Strategy and Custom transformations within the session
mapping to determine how to flag rows for insert, delete,
update, or reject.
If the mapping for the session contains an Update Strategy
transformation, this field is marked Data Driven by
default.
If you do not choose Data Driven when a mapping contains an
Update Strategy or Custom transformation, the Workflow
Manager displays a warning.

Answer / srinu

data driven is a set of rules.based upon this rules the
integration service perfoms all operations in update
strategy transformation.
DD_INSERT
DD_UPDATE
DD_REJECT
DD_DELETE

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

0 Answers  

---

can we create index and drop index in exsisting table while using infomatica

4 Answers  

---

can we use bulk loading when we use look in mapping

1 Answers   TCS,

---

how to return multiple columes through through un-connect lookup?

1 Answers   DELL,

---

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

0 Answers  

---

What is lookup change?

0 Answers  

---

what is incremental data aggregation?

3 Answers   IBM,

---

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

0 Answers  

---

Which means the first record should come as last record and last record should come as first record and load into the target file?

0 Answers   Informatica,

---

To import the flat file definition into the designer where should the flat file be placed?

0 Answers   Informatica,

---

What is the Difference between SetVariable and setmaxvariable in informatica?

1 Answers  

---

There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?

1 Answers   Accenture,

---