Author Archives: Admin

Installing Oracle Applications E-Business Suite R12 (12.1.1) on Windows XP / Windows 2003 Server

Minimum Hardware Requirements: 1. Windows XP (professional or Home) Service Pack 2 / Windows 2003 Server with 2 GB RAM and make sure you have NTFS file system. 2. Hard Disk 250 GB where 233 GB space is required for … Continue reading

Posted in General, Oracle Applications | Tagged , | 1 Comment

De-Normalization Techniques

While building the Data Warehouse, these are five most common techniques of De-normalization: 1) Collapsing Tables 2) Pre-Joining 3) Splitting Tables a) Horizontal Splitting b) Vertical Splitting 4) Adding Redundant Columns 5) Derived Attributes

Posted in Data Warehousing | Tagged | 1 Comment

Developing Sales Business Area by Using Oracle BI Discoverer Administrator – Part 4

Creating a New Business Area i) When the EUL Manager screen will be closed, the following screen will be displayed. Click on the “Create a new business area” and click Next. ii) Select the sales database. I have created a … Continue reading

Posted in BI Discoverer, Business Intelligence (BI) | Tagged | 2 Comments