Data Warehouse Web Portal --- ETL I Reporting Tool

DWHlabs provides Data Warehouse education services.This web portal is very useful to the Database professionals,
Data Warehouse professionals, UNIX professionals etc.,

About Us

Advertise

Support us

Tell your Fren

Testimonial

Please help us continue development of this website and it's services!

Donation Campaign
Donors List

DWHlabs- ETL TOOL

Sponsered Links

Design a mapping to move first half of the data to one target and second half of the data to other target? eg., if you 20 records in source - first 10 to one target and other 10 to second target or if your source records have odd number first n/2 +1 in one target and other in second target?

Mapping

first half to one target and second half to other target.

Solution

Source : Flatfile
Target : Relational
Database : Oracle

Tip : use stored procedure to count the records

Download

XML FILE
m_firsthalf_secondhalf

DWH 3Colors
	CERTIFICATION GUIDE
	DATA DICTIONARY
	ALL ARTICLES

DWH CONCEPTS

DWH Architecture
Types of Schema
Normalization

FAST LINKS

Transformation Mappings
Real Time Mappings
Informatica Tutorial
UNIX in 15 Days

VS LINKS

OLAP Vs OLTP
Dimension Table Vs Fact Table
Datamart Vs Data Warehouse
Data Mining Vs Web Mining

SHARE KNOWLEDGE

Now viewers can share their information with DWHlabs , please Click Here.
Please send your feedback Click Here .
Tell you friend about DWHlabs Click Here .

Home Page

Data Warehouse Lab

- ETL TOOL

	INFORMATICA
	OTHER TOOLS

- REPORTING TOOL

	BUSINESS OBJECTS
	OTHER TOOLS

Database Lab

- ORACLE

	SQL
	PL/SQL

- DB2

OTHER TOOLS

Unix Lab

	15 DAYS TUTORIAL
	SHELL SCRIPTING

Project Lab

	S PROJECTS
	CASE STUDY

DWH Schools

	INDIA
	ABROAD

Books Store

	Data Warehouse
	ETL Tool
	Reporting Tool
	Database
	Unix