Skip to Content
0
Former Member
May 09, 2007 at 02:31 AM

Flat File Extraction

223 Views

Hello Experts,

I am in the process of loading an InfoCube from the data in a flat file. However, the problem is that the flat file has both master data and transaction data where as the InfoCube (Fact Table) would be having DIM Ids and Key Figures ( Transaction Data)

To make things simpler, this is how my transaction data is

Legal Entity, Cost Center, Account, Amount

1000, 108000,235600, 250

Which is a mix of Master Data ( LE, CC, A/C) and Transactional Data ( 250) - I was not provided any other table to load master data seperately ...

So what do u think i need to do ?

All answers/ideas will be duly rewarded.

Thanks,

Ram