Skip to Content
0
Former Member
Apr 09, 2008 at 06:05 PM

How can I add duplicate records in an ODS?

15 Views

Hi guys,

I have an input file that may contain dupplicate records for the key. I am having trouble loading to an ODS because the key is duplicated. Is there a way to have one register in the ODS with sum of the duplicate records?

Ex:

Input File:

YEAR COMPANY VALUE

-


2007 COMPANY1 2.00

2008 COMPANY1 2.00

2008 COMPANY1 2.00

2008 COMPANY2 2.00

Expected data in ODS:

YEAR COMPANY VALUE

-


2007 COMPANY1 2.00

2008 COMPANY1 4.00

2008 COMPANY2 2.00

help will be rewarded

Thx

DGF