source
name sal
aaaa 2000
bbbb 3000
abcd 5000
Target
name sal
aaaa 2000
bbbb 3000
abcd 5000
total 10000
how to get total as new row and sum as 10000
thanks
Answer Posted / babu
Hi Chinthi
You will do the above mapping,definely you can get
whatever you want.
Please check and intimate in case of any issues.
dwarak.vbr@gmail.com
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What are the components of the workflow manager?
What does refresh system mean, and what are its distinctive choice?
Slowly changing dimensions, types and where will you use them
how we can load rejected record's at run time?(not through bad files)
COM components can be used in Informatica
what is size of u r database?
Can we create a Integration service without a Repository service and vice versa?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
lookup transformation with screenshots
What do you mean by worklet?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Which is the t/r that builts only single cache memory?
what is Active lock explain
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
Which means the first record should come as last record and last record should come as first record and load into the target file?