Skip to Content
0
Former Member
Apr 29, 2015 at 10:34 AM

Duplicate records in Cube for 2 dso

45 Views

Hi,

The business scenario requires me to extract data from two flat file on to two DSO. From these two DSO to a cube. The problem i am facing is that there are duplicate records in cube.

Scenario:

These are the few field in dso 1 (say 20 rec)

Mat no

Mat Name

Mat type

The fields in DSO2 are (20 rec)

Mat no

Mat Qty

Mat amt

The IC should display only the following fields

Mat no

Mat name

Mat amt

What is happening in the IC is that i am getting 20 record from DSO1 for Mat no and mat name and another 20 record from DSO 2 for Mat no and Mat amt.(both the mat no are same for both DSO).

I have done one to one mapping in all transformations. Do i need to write a routine instead? If yes help me with the routine.

Thanks