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!
 
 

 


 
 

Sponsered Links
 
 
MAPPING TEST
  1 | 2
6. I have Empno,Name ,Loc in the source table , we have two targets the 1st target is Tgt_ india and Tgt_USA. when the employee moves from india to USA the row of that employee must be inserted in USA tgt and must be deleted in Indian tgt and vice versa.

Solution :: Click Here
 
7. How to convert incorrect phone number to correct phone number ?eg., 100er$556%%3457 to 100-556-3457

Solution :: Click Here
 
8. Develop a mapping

Source Definition Target Definition
EMP
COMPANY SALARY_MONTH YEAR
JOHN WIPRO 10000 2001
JOHN IFLEX 20000 2003
JOHN HP 30000 2004
JOHN SATYAM 60000 2008
LUCKY CTS 20000 2006
LUCKY EDS 35000 2008
EMP
ALL_COMPANY HIGH_SAL
JOHN WIPRO,IFLEX,HP,SATYAM 60000
LUCKY CTS,EDS 35000


Solution :: Click Here
 
9. Develop a mapping , where it removes the duplicate records from 3rd duplicate record onwards.
Source Definition Target Definition
CODE
COMPANY
100 WIPRO
100 WIPRO
101 HP
101 HP
100 WIPRO
100 WIPRO
102 SATYAM
COM_CODE
COMPANY
100 WIPRO
100 WIPRO
101 HP
101 HP
102 SATYAM
 
10.Design a mapping , which generates rank - without using rank transformation
Source Definition Target Definition
Name
Sal
Raj 200
Ram 300
Rak 300
Lok 400
Tag 300
Brav 500
Sat 600
Nag 500
O_RANK
NAME SAL
1 Raj 200
2 Ram 300
2 Rak 300
2 Tag 300
4 Lok  400
5 Brav 500
5 Nag 500
7 Sat 600

 

Submit Mapping ::

Think you've designed a Mapping for the above questions or if you have your own developed mapping  and would like the world to see it? Submit it to DWH labs then!

 you can submit your code to dwhlabs.in@gmail.com . Please either zip up the code, or simply post a URL to it in your email.

Request ::

Please mention the tool name and its version.

Important:

By submitting, you represent that you are the original creator of the Mapping, and grant DWH labs the full right to include and feature your Mapping in our Mapping archive and possibly through other sources affiliated with DWH labs. We also reserve the right to modify or remove the script from our site at any time.

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