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
1.Design a mapping to load the duplicate records into duplicate table and unique records into unique table ?

Solution :: Click Here

2. Design a mapping

DATE
MEM_ID
CLAIM_ID
AMOUNT
08-APR-2008
001
2
40
07-APR-2008
001
2
30
06-APR-2008
001
2
50
01-APR-2008
001
2
20
23-MAR-2008
001
2
46

you have to ignore the latest record for calculations i.e. 8Apr record has to be ignored. Then you have to calculate a ratio for the other dates ....

Hint :: 30/50 +50/20+20/46 =???

Solution :: Click Here

3. Design a mapping, first two phone calls received by a customer must be represented as "Home" , "Office" and the next calls must be concatinated and represented as "Other".Look at the below tables ::


Source Definition
Customer
Phone_Number
A 9848403211
A 9812675432
A 9112356788
A 9876503276
B 9567890765
B 9876098567
Customer Home Office Other
A 9848403211 9812675432 9112356788,9876503276
B 9567890765 9876098567 null

Solution :: Click Here
 
4. Design a mapping, to load the records according to gender wise.Like as shown in below
 
Source Definition Target Definition
Name
Gender
Ramya Female
Raj Male
Prema Female
Sony Female
Smith Male
Lucky Male
Male
Female
Raj Ramya
Smith Prema
Lucky Sony
 

Solution :: Click Here
 

5. In source i have 1000 rows and i have 3 tragets . The 1st 100 rows have to go in 1st target and the next 200 rows in 2nd traget and the rest of the rows in the 3rd tgt?

Solution :: Click Here

  1 | 2
 

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.



  Refer Us ::Hope you are enjoying each and every link presented here .Its time to surprise your fren by refering us to them.Now it is very easy to refer us to your friends Click Here
 
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