Skip to Content
0
Former Member
Dec 11, 2006 at 02:40 AM

Loading Data from 3 Flat Files (i.e. 3 DataSource) to One InfoCube

80 Views

Hi,

To load data from 3 Flat Files (i.e. 3 DataSources) in to One InfoCube, I did the following. Please let me know if my design is correct or not, as I am getting a Short Dumb while loading the data.

1. Created 3 DataSources DS1, DS2, DS3

2. Created InfoPackage for 3 DataSources

3. Created 3 Transformations for each DataSource and assigned only One InfoSource "IS1" as a Target to all the 3 DataSources

4. Created a InfoCube IC1

5. Created Tranformation between InfoSource "IS1" (as DataSource) and InfoCube IC1 (as Data Target)

6. Created THREE DTP's for each DataSource DS1, DS2, and DS3 to load data in to the InfoCube IC1 through the InfoSource IS1.

I am not sure about the 6th step as do I have to create 3 DTP's.......each for each DataSource.

Please let me know if I am missing any thing.

Your help is appreciated. I will assign the points. Thank You!