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

Design a mapping

DWHlabs- ETL TOOL

Sponsered Links

MAPPINGS PAGE - REAL TIME MAPPINGS

General Mappings

How to find the number of success , rejected and bad records in the same mapping.

Increamental Data load code using SQL Override logic

Flat File Validation Mappings

How to filter the Null Value data ?

How to filter the improper Date format data?

How to correct the data values without spaces?

How to convert flatfile Date datatype ( string) into Relational Date datatype (Date) ?

Design a mapping to validate the records which are extrated from a flatfile.

Function Mappings

How to use "REPLACECHR" functiion ?

How to work with "SUBSTR" function?

Warehouse Mappings

Design a simple mapping to acheive SCD type1.

Design a mapping to preapre the warehouse from a valid records.

I have 4 million records in my source as a flat file . i want to load the records to target. Target has four table . In the mapping , first record should go to firat table , second record will go to second table, 3rd record goes to 3rd table, 4th record goes to 4th table , Again 5th record goes to first table and then Continue the same process . How can u do this ?

Design a mapping

Source Definition

Target Definition

Level1	Level2
P1	P2
P2	P3
P3	P4

level1	level2	level3	level4
p1	p1	p1	p1
p1	p2	p2	p2
P1	p2	p3	p3
p1	p2	p3	p4

Design a mapping

Source Definition

Target Definition

ID	Name
1	100
2	Ramesh
3	INDIA
1	101
2	Rakesh
3	INDIA
1	102
2	Johny
3	USA

EID	ENAME	COUNTRY
100	Ramesh	INDIA
101	Rakesh	INDIA
102	Johny	USA

Design a mapping

Source Definition

Target Definition

EMP_NO	ESAL
10	2Hundred
11	10Thousand
12	15Lakhs
13	170

EMP_NO	ESAL
10	200.00
11	10000.00
12	15000000.00
13	170.00

Design a mapping , which generates sequence of numbers using setvariable function in exp transformation( without using sequence generator)

How to seperate or remove duplicate records from the source table ? or segregate unique and duplicate records . (using mapping variables)

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?

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