Posts

Showing posts from December, 2011

sqlloader

Image
SQL LOADER SQL LOADER utility is used to load data from other data source into Oracle. For example, if you have a table in FOXPRO, ACCESS or SYBASE or any other third party database, you can use SQL Loader to load the data into Oracle Tables. SQL Loader will only read the data from Flat files. So If you want to load the data from Foxpro or any other database, you have to first convert that data into Delimited Format flat file or Fixed length format flat file, and then use SQL loader to load the data into Oracle. Following is procedure to load the data from Third Party Database into Oracle using SQL Loader. 1. Convert the Data into Flat file using third party database command. 2. Create the Table Structure in Oracle Database using appropriate datatypes 3. Write a Control File, describing how to interpret the flat file and options to load the data. 4. Execute SQL Loader utility specifying the control fi

ODI (Oracle Data Integrator) -Oracle BAM Integration

Image
                                          ODI AND ORACLEBAM INTEGRATION ODI-BAM INTEGRATION STEPS: Supported Version: Oracle BAM 11G and Oracle Data Intergrator 10.3.5 Objectives: This document provides step-by-step instructions to manipulate data in Oracle BAM using Oracle Data Integrator. This tutorial showcases the use of customized Oracle BAM knowledge modules to extract data and insert it back into the application. Prerequisite: Basic knowledge of Oracle BAM and Oracle Data Integrator Installed Oracle BAM software Oracle Data Integrator 10.1.3.5 installed with Master and Work repositories Configured Oracle BAM- Oracle Data Integrator integration Set Up the Environment: ODI: 1. Open Oracle BAM Architect and select the External Data Sources page. 2. Click Create, and configure the two external data sources (ODI_Master and ODI_ Work) with the values shown in below ODI_Master external data source values Property Value External Data Source Name :ODI_Maste

error: Failed dependencies:lsb >= 3.1 is needed by RealPlayer-11.0.1.1056-20081001.i586

Image
Solution: su - yum install redhat-lsb rpm -ivh RealPlayer11GOLD.rpm For references: http://forums.fedoraforum.org/showthread.php?t=21364&page=4

Installing broadcom wireless driver for linux fedora 15 32 bit

For rpmfusion free release $ su -c 'rpm -Uvh http://download1.rpmfusion.org/free/fedora/rpmfusion-free-release-stable.noarch.rpm' For rpmfusion non free release                                                                    $ su -c 'rpm -Uvh http://download1.rpmfusion.org/nonfree/fedora/rpmfusion-nonfree-release-stable.noarch.rpm'   Once you have upgraded the rpmfusion free and non-free release in your system then update the system using the following command. Type the password for the user when prompted.                                                                $ sudo yum update Download the package broadcom-wl-4.150.10.5.tar.bz2 from http://mirror2.openwrt.org/sources/broadcom-wl-4.150.10.5.tar.bz2 unzip or extract the tar file to local folder and do the following: su - chmod -R 777 broadcom-wl-4.150.10.5/ cd broadcom-wl-4.150.10.5/driver b43-fwcutter -w /lib/firmware wl_apsta_mimo.o Restart your machine More references Pls visit the