Interested to Buy Any Domain ? << Click Here >> for more details...
Whatis the difference between View and Materialized View ?
- 11 Answers
- 56116 Views
- Satyam, Syntel, I also Faced
- E-Mail Answers
Answer Posted / guest
In view we cannot do DML commands where as it is possible
in Materialized view.
| Is This Answer Correct ? | 39 Yes | 121 No |
Post New Answer View All Answers
Explain how many types of dimensions are available 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 lookup transformation?
What are the guidelines to be followed while using union transformation?
What is exclusive and normal mode for repository services?
While migrating the data from one environment to another environment how would you manage the connections?
how to create user defined function (udf) in informatica
What is mapplet in informatica?
Informatica settings are available in which file?
What is a shortcut and copy in Informatica and how two are different with each other?
How to Create a folder using pmrep command?
How can we update a record in the target table without using update strategy?
Define Pmrep command?
Which transformation should we use to normalise the COBOL and relational sources?
What is meant by LDAP users?
