what is meant by data driven.. in which scenario we use
that..?
Answer Posted / teja_dwh
Data driven is nothing but but instruct the source rows that
should take action on target i.e(update,delete,reject,insert).
If we use the update strategy transformation in a mapping then
will select the datadriven option in session.
reply me if am wrong
teja_dwh@yahoo.com
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is the reusable transformation?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is the benefit of session partitioning?
What you know about transaction control transformation?
What is the difference between informatics 7x and 8x and what is latest version?
How can we update a record in the target table without using update strategy?
What is informatica?
What are multi-group transformations?
How many ways are there to create ports?
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
Enlist few areas or real-time situations where informatica is required.
In how many ways we can create ports?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Can anyone tell me the new features in Informatica 9 Version?