Home | Contact Us | Sitemap
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 Contact Us  
 
 
Please help us continue development of this website and it's services!
 
 

 

 
DWHlabs- ETL TOOL
TUTORIALS
MAPPINGS
VIDEOS
BOOKS
QUESTIONS
Sponsered Links
 
 
Design a mapping , which generates sequence of numbers using setvariable function in exp transformation( without using sequence generator)
 
Mapping : Design a mapping as shown below

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
Solution :
Source : Flatfile
Target : Relational
 
Download :
XML FILE  
m_verticle_hor  
  Orkut Query
DWH 3Colors
CERTIFICATION GUIDE
DATA DICTIONARY
ALL ARTICLES
   
DWH CONCEPTS

DWH Architecture
Types of Schema
Normalization
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 .


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

Project Lab

DWH Schools

Books Store



 
  About Us Advertise Support us Tell your Fren Testimonial Contact Us  
© 2008 DWHlabs
Privacy Policy | Terms & Conditions