Prepare for your Next Interview

• GeekInterview
• Knowledge base
• Interview Questions
• Tech FAQs

Mapping scenario

This is a discussion on Mapping scenario within the Data Warehousing forums, part of the Databases category; My source data is a flat file and it has empid, deptid and 12 columns for salaries of each month (jan-dec). Now my requirement is to create one record ...

Geeks Talk > Databases > Data Warehousing Mapping scenario

User Name Remember Me? Password

Register

FAQ

Members List

Calendar

Mark Forums Read

Thread Tools

Display Modes

#1 (permalink)   03-23-2008

tanya_j Junior Member   Join Date: Mar 2008 Posts: 22 Thanks: 1 Thanked 2 Times in 2 Posts

Mapping scenario My source data is a flat file and it has empid, deptid and 12 columns for salaries of each month (jan-dec). Now my requirement is to create one record for each month and also running total of the salary. What type of transformations should be used?

Sponsored Links

#2 (permalink)   03-25-2008

cme_prak Contributing Member   Join Date: Dec 2007 Location: INDIA Posts: 36 Thanks: 1 Thanked 6 Times in 6 Posts

Re: Mapping scenario Hi, SRC ---> EXP ---->[use CUME function to get the running total] ------>AGG----->TAR Thx, Prakash

Geeks Talk > Databases > Data Warehousing

« update strategy | Rows to columns and vice-versa »

Thread Tools

Show Printable Version Email this Page

Display Modes

Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Test Scenario	perumalt	Testing Issues	2	02-25-2008 10:29 AM
Test Scenario	hari82	Test Cases	2	02-08-2008 03:27 AM
Mapping and Auxiliary Mapping?	sanghala	Data Warehousing	0	08-21-2007 06:25 AM
Scenario	vijenjoy2k2	LoadRunner	1	07-16-2007 05:41 PM
Help with a Scenario	Samrasr	Interviews	0	02-22-2007 01:07 PM

All times are GMT -4. The time now is 08:06 AM.