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.
These are the few field in dso 1 (say 20 rec)
The fields in DSO2 are (20 rec)
The IC should display only the following fields
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.