saurav-mitra.blogspot.com

All about Data Warehouse and Business Intelligence

All about Data Warehouse and Business Intelligence. All about Data Warehouse and Business Intelligence. Can be defined as a centralized, consistent data store or Decision Support System (OLAP), for the end business users for analysis, prediction and decision making in their business operations. Data from various enterprise-wide application/transactional source systems (OLTP), are extracted, cleansed, integrated, transformed and loaded in the DWH. Properties of a Data Warehouse:-. Describes processing of ...

http://saurav-mitra.blogspot.com/

OVERVIEW OF saurav-mitra.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

10

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR SAURAV-MITRA.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

June

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Friday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 4.4 out of 5 with 17 reviews

5 star

9

4 star

6

3 star

2

2 star

0

1 star

0

Hey there! Start your review of saurav-mitra.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.7 seconds

FAVICON PREVIEW

16x16
32x32
64x64
128x128

CONTACTS AT SAURAV-MITRA.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

10

SSL

EXTERNAL LINKS

22

SITE IP

216.58.216.193

LOAD TIME

0.719 sec

SCORE

6.2

PAGE TITLE

All about Data Warehouse and Business Intelligence | saurav-mitra.blogspot.com Reviews

<META> DESCRIPTION

All about Data Warehouse and Business Intelligence. All about Data Warehouse and Business Intelligence. Can be defined as a centralized, consistent data store or Decision Support System (OLAP), for the end business users for analysis, prediction and decision making in their business operations. Data from various enterprise-wide application/transactional source systems (OLTP), are extracted, cleansed, integrated, transformed and loaded in the DWH. Properties of a Data Warehouse:-. Describes processing of ...

<META> KEYWORDS

1 visit dwbi concepts

2 visit zr india

3 datawarehouse

4 a data warehouse

5 oltp and olap

6 posted by

7 saurav mitra

8 3 comments

9 email this

10 blogthis

CONTENT

Page content here

KEYWORDS ON PAGE

visit dwbi concepts,visit zr india,datawarehouse,a data warehouse,oltp and olap,posted by,saurav mitra,3 comments,email this,blogthis,share to twitter,share to facebook,share to pinterest,oracle analytic functions,over,query partition clause,an example

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

All about Data Warehouse and Business Intelligence | saurav-mitra.blogspot.com Reviews

https://saurav-mitra.blogspot.com

All about Data Warehouse and Business Intelligence. All about Data Warehouse and Business Intelligence. Can be defined as a centralized, consistent data store or Decision Support System (OLAP), for the end business users for analysis, prediction and decision making in their business operations. Data from various enterprise-wide application/transactional source systems (OLTP), are extracted, cleansed, integrated, transformed and loaded in the DWH. Properties of a Data Warehouse:-. Describes processing of ...

INTERNAL PAGES

saurav-mitra.blogspot.com

1

All about Data Warehouse and Business Intelligence: SQL Tutorial for Beginners Part III

http://saurav-mitra.blogspot.com/p/sql-tutorial-for-beginners-part-iii.html

All about Data Warehouse and Business Intelligence. All about Data Warehouse and Business Intelligence. SQL Tutorial for Beginners Part III. 8226; Manipulate data items. 8226; Accept arguments and return one value. 8226; Act on each row returned. 8226; Return one result per row. 8226; May modify the data type. 8226; Can be nested. Single Row Functions: Numeric. 8226; NVL: NVL will convert the NULL value to the required value. SELECT sal NVL(comm,0) FROM emp;. SELECT ABS(-10) FROM dual;. O/p -1 0 1. Singl...

2

All about Data Warehouse and Business Intelligence: SQL Tutorial for Beginners Part I

http://saurav-mitra.blogspot.com/p/page-test.html

All about Data Warehouse and Business Intelligence. All about Data Warehouse and Business Intelligence. SQL Tutorial for Beginners Part I. We human beings communicate with each other with the help of language. SQL. Database gateway Language standardized by ANSI. It is the language that a database understands and we will communicate to the database using SQL. SQL stands for Structured Query Language. SQL Commands are divided into following categories:. 1 Data Definition Language. 8226; CREATE, ALTER, DROP.

3

All about Data Warehouse and Business Intelligence: April 2010

http://saurav-mitra.blogspot.com/2010_04_01_archive.html

All about Data Warehouse and Business Intelligence. All about Data Warehouse and Business Intelligence. Oracle provides many Analytic Functions such as. AVG, CORR, COVAR POP, COVAR SAMP, COUNT, CUME DIST, DENSE RANK, FIRST, FIRST VALUE, LAG, LAST, LAST VALUE, LEAD, MAX, MIN, NTILE, PERCENT RANK, PERCENTILE CONT, PERCENTILE DISC, RANK, RATIO TO REPORT, STDDEV, STDDEV POP, STDDEV SAMP, SUM, VAR POP, VAR SAMP, VARIANCE. The Syntax of analytic functions:. Analytic-Function(Column1,Column2,.). Oracle can pars...

4

All about Data Warehouse and Business Intelligence: Oracle Analytic Functions

http://saurav-mitra.blogspot.com/2010/04/oracle-analytic-functions.html

All about Data Warehouse and Business Intelligence. All about Data Warehouse and Business Intelligence. Oracle provides many Analytic Functions such as. AVG, CORR, COVAR POP, COVAR SAMP, COUNT, CUME DIST, DENSE RANK, FIRST, FIRST VALUE, LAG, LAST, LAST VALUE, LEAD, MAX, MIN, NTILE, PERCENT RANK, PERCENTILE CONT, PERCENTILE DISC, RANK, RATIO TO REPORT, STDDEV, STDDEV POP, STDDEV SAMP, SUM, VAR POP, VAR SAMP, VARIANCE. The Syntax of analytic functions:. Analytic-Function(Column1,Column2,.). Why RDBMS again...

5

All about Data Warehouse and Business Intelligence: DataWarehouse

http://saurav-mitra.blogspot.com/2010/07/datawarehouse.html

All about Data Warehouse and Business Intelligence. All about Data Warehouse and Business Intelligence. Can be defined as a centralized, consistent data store or Decision Support System (OLAP), for the end business users for analysis, prediction and decision making in their business operations. Data from various enterprise-wide application/transactional source systems (OLTP), are extracted, cleansed, integrated, transformed and loaded in the DWH. Properties of a Data Warehouse:-. Describes processing of ...

UPGRADE TO PREMIUM TO VIEW 5 MORE

TOTAL PAGES IN THIS WEBSITE

10

LINKS TO THIS WEBSITE

data-warehouse-science.blogspot.com

Science of Data: June 2010

http://data-warehouse-science.blogspot.com/2010_06_01_archive.html

This blog publishes supplementary discussions on articles published in DWBI Concepts. Along with anything related to data warehousing, BI and my life! Friday, June 25, 2010. Can a Oracle parallel hint be evil? About Oracle query hint, this is often said that - "An hint, if ignored by Oracle, is just a comment". But I didn't think that a "mere" hint can lead to a job failure also. But I was wrong. Very Very wrong. I put the question to Tom Kyte's forum asktom and here. Is the answer I got,. Google Insight...

data-warehouse-science.blogspot.com

Science of Data: August 2010

http://data-warehouse-science.blogspot.com/2010_08_01_archive.html

This blog publishes supplementary discussions on articles published in DWBI Concepts. Along with anything related to data warehousing, BI and my life! Monday, August 30, 2010. Should we keep Index and Data in separate tablespace? Index and Data in Separate Tablespaces. While DBA wants developers to change the code to create the indexes in the proper tablespace, developers’ argument is why creating indexes in a different tablespace are so important? Why do you need a separate Tablespace for Indexes? There...

data-warehouse-science.blogspot.com

Science of Data: March 2011

http://data-warehouse-science.blogspot.com/2011_03_01_archive.html

This blog publishes supplementary discussions on articles published in DWBI Concepts. Along with anything related to data warehousing, BI and my life! Saturday, March 12, 2011. List of Fourth-coming articles in DWBIConcepts.com. Currently working on the following articles for www.DWBIConcepts.com:. 1 A primer on Informatica MetaData Repository Tables. 2 Benefits and troubles of Informatica Persistent Cache. 3 Writing SQL Query to extract simple information from Informatica Metadata tables.

data-warehouse-science.blogspot.com

Science of Data: July 2010

http://data-warehouse-science.blogspot.com/2010_07_01_archive.html

This blog publishes supplementary discussions on articles published in DWBI Concepts. Along with anything related to data warehousing, BI and my life! Saturday, July 10, 2010. Compare between CTAS, COPY and DIRECT PATH Load in Oracle. OK Here is a simple task that I am trying to achieve all through out tonight. Loading Huge Table Over DBLINK. When I started to think about this, following options came into my mind:. 1 Using Transportable Table Space. 2 Using CTAS over DBLink. 3 Using direct load path.

data-warehouse-science.blogspot.com

Science of Data: Can a Oracle parallel hint be evil?

http://data-warehouse-science.blogspot.com/2010/06/can-oracle-parallel-hint-be-evil.html

This blog publishes supplementary discussions on articles published in DWBI Concepts. Along with anything related to data warehousing, BI and my life! Friday, June 25, 2010. Can a Oracle parallel hint be evil? About Oracle query hint, this is often said that - "An hint, if ignored by Oracle, is just a comment". But I didn't think that a "mere" hint can lead to a job failure also. But I was wrong. Very Very wrong. I put the question to Tom Kyte's forum asktom and here. Is the answer I got,. Parallel PL/SQ...

data-warehouse-science.blogspot.com

Science of Data: April 2010

http://data-warehouse-science.blogspot.com/2010_04_01_archive.html

This blog publishes supplementary discussions on articles published in DWBI Concepts. Along with anything related to data warehousing, BI and my life! Monday, April 19, 2010. Saurav has posted a new article here. On Incremental Aggregation Using Informatica. The need of incremental aggregation arise when we capture our source data (transactional data) incrementally in a frequency faster than the aggregation period. Sunday, April 18, 2010. 1 Detail Oracle Server Architecture. Let me know your comments.

data-warehouse-science.blogspot.com

Science of Data: List of Fourth-coming articles in DWBIConcepts.com

http://data-warehouse-science.blogspot.com/2011/03/list-of-fourth-coming-articles-in.html

This blog publishes supplementary discussions on articles published in DWBI Concepts. Along with anything related to data warehousing, BI and my life! Saturday, March 12, 2011. List of Fourth-coming articles in DWBIConcepts.com. Currently working on the following articles for www.DWBIConcepts.com:. 1 A primer on Informatica MetaData Repository Tables. 2 Benefits and troubles of Informatica Persistent Cache. 3 Writing SQL Query to extract simple information from Informatica Metadata tables.

data-warehouse-science.blogspot.com

Science of Data: Compare between CTAS, COPY and DIRECT PATH Load in Oracle

http://data-warehouse-science.blogspot.com/2010/07/compare-between-ctas-copy-and-direct.html

This blog publishes supplementary discussions on articles published in DWBI Concepts. Along with anything related to data warehousing, BI and my life! Saturday, July 10, 2010. Compare between CTAS, COPY and DIRECT PATH Load in Oracle. OK Here is a simple task that I am trying to achieve all through out tonight. Loading Huge Table Over DBLINK. When I started to think about this, following options came into my mind:. 1 Using Transportable Table Space. 2 Using CTAS over DBLink. 3 Using direct load path.

data-warehouse-science.blogspot.com

Science of Data: Should we keep Index and Data in separate tablespace?

http://data-warehouse-science.blogspot.com/2010/08/index-and-data-in-separate-tablespaces.html

This blog publishes supplementary discussions on articles published in DWBI Concepts. Along with anything related to data warehousing, BI and my life! Monday, August 30, 2010. Should we keep Index and Data in separate tablespace? Index and Data in Separate Tablespaces. While DBA wants developers to change the code to create the indexes in the proper tablespace, developers’ argument is why creating indexes in a different tablespace are so important? Why do you need a separate Tablespace for Indexes? There...

UPGRADE TO PREMIUM TO VIEW 13 MORE

TOTAL LINKS TO THIS WEBSITE

22

OTHER SITES

saurau.com

Web Page Under Construction

This Site Is Under Construction and Coming Soon. This Domain Is Registered with Network Solutions.

sauraufall.skyrock.com

Blog de sauraufall - saurau fall - Skyrock.com

Mot de passe :. J'ai oublié mon mot de passe. Je mappell saurau pleasss laise vos commm. Mise à jour :. Abonne-toi à mon blog! N'oublie pas que les propos injurieux, racistes, etc. sont interdits par les conditions générales d'utilisation de Skyrock et que tu peux être identifié par ton adresse internet (67.219.144.114) si quelqu'un porte plainte. Ou poster avec :. Retape dans le champ ci-dessous la suite de chiffres et de lettres qui apparaissent dans le cadre ci-contre. Ou poster avec :. N'oublie pas q...

saurav-ghimire.blogspot.com

Pharma-Info

Scholarships for Pharmacy Students in Korea. Monday, September 9, 2013. First of all i would like to apologize with everyone because i could not be in touch with my blog for two years. Regardless of it now i will be actively participating and updating you everything about my experiences and scholarships regarding various fields that i know. Thursday, September 1, 2011. Role of Pharmacist in Traditional and Allopathic Medicine. The traditional role of pharmacists is to manufacture and supply medicines&#46...

saurav-glimpsesofindia.blogspot.com

Saurav Pandey - Glimpses of India

Saurav Pandey - Glimpses of India. Showing a facet of India, one at a time. Enter your search terms. Friday 18 March 2011. Big Banyan Tree, Bangalore. See my flickr set - http:/ www.flickr.com/photos/hellosaurav/sets/72157625801074044/. Posted by Saurav Pandey. Friday 11 March 2011. Pictures from Bannerghatta National Park, Bangalore [ Wikipedia. Pictures at the Zoo. Pictures at the Safari. Pictures from the Butterfly Park. Posted by Saurav Pandey. Tuesday 25 January 2011. Posted by Saurav Pandey. The ro...

saurav-harsh.deviantart.com

Saurav-Harsh (Saurav Harsh) - DeviantArt

Window.devicePixelRatio*screen.width 'x' window.devicePixelRatio*screen.height) :(screen.width 'x' screen.height) ; this.removeAttribute('onclick')" class="mi". Window.devicePixelRatio*screen.width 'x' window.devicePixelRatio*screen.height) :(screen.width 'x' screen.height) ; this.removeAttribute('onclick')". Join DeviantArt for FREE. Forgot Password or Username? Deviant for 2 Years. This deviant's full pageview. Last Visit: 2 weeks ago. This is the place where you can personalize your profile! 42 / 1,200.

saurav-mitra.blogspot.com

All about Data Warehouse and Business Intelligence

All about Data Warehouse and Business Intelligence. All about Data Warehouse and Business Intelligence. Can be defined as a centralized, consistent data store or Decision Support System (OLAP), for the end business users for analysis, prediction and decision making in their business operations. Data from various enterprise-wide application/transactional source systems (OLTP), are extracted, cleansed, integrated, transformed and loaded in the DWH. Properties of a Data Warehouse:-. Describes processing of ...

saurav-nav.blogspot.com

Saurav Dhyani - Microsoft Dynamics Navision

Saurav Dhyani - Microsoft Dynamics Navision. Please add comments and Rate the article so that others find the articles easily. Thursday, August 13, 2015. NAV 2013 - cumulative update 29 Released. Please find below the details of Cumulative Update 29 released for Microsoft Dynamics NAV 2013. Title - Cumulative update 29 for Microsoft Dynamics NAV 2013 . Build No. -. Local Version Included -. Thursday, August 13, 2015. Location: Chennai, Tamil Nadu, India. NAV 2013 R2 - Cumulative Update 22 Released. Monda...