Hi,
I have to load 5 flat files in to one info cube. Could any one give me a good design, how to do this using Transformations and DTP in BI 7.0.
e.g. DS1DS2.....DSN --> Transformation --> InfoSource --> Transformation -->InfoCube
Does the above design work.
Is there a way that I can design the above with out using an InfoSource?
Suggestions for the good design are appreciated.
Thank You.