How will you update the first four rows and insert next
four rows in a mapping?
- 5 Answers
- 9064 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / vali
i can explain it more clear that we have to place a rank
t/r before router and create two groups in router and given
it to update strategy....
src->sq->rank->router->ups->trg
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How to start a workflow using pmcmd command?
Is it possible to define a single node as a Gateway node as well as worker node?
Why union transformation is an active transformation?
What are the new features of informatica 9.x developer?
What is the commit type if you have a transaction control transformation in the mapping?
How to extract the informatica rejected data?
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
What is aggregator transformation in informatica?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How can you differentiate between powercenter and power map?
What is a sequence generator transformation?
What are the differences between joiner transformation and source qualifier transformation?
Why sorter is an active transformation?
Explain constraint based loading in informatica
How we can create indexes after completing the load process?
