Interested to Buy Any Domain ? << Click Here >> for more details...
What is an MDDB? What is the difference between MDDBs and
RDBMSs?
- 3 Answers
- 19774 Views
- I also Faced
- E-Mail Answers
Answer Posted / lok
in mddb we can analyze the data in multiple ways,here we
can create power cubes.
but in rdbm we can create cross tab reports,simple list
reports.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What are the static cache and dynamic cache in informatica?
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 an expression transformation in informatica?
Differentiate between a repository server and a powerhouse?
How to create a non-reusable instance of reusable transformations?
What is event and what are the tasks related to it?
What are the types of lookup transformation?
What is mapping debugger?
Enlist the tasks for which source qualifier transformation is used.
Is it possible to create multiple domains on a single Informatica server?
Under which circumstances, informatica server creates reject files?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What is data movement mode in Informatica and difference between them?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Explain joiner transformation in informatica
