Skip to Content
Former Member
Oct 22, 2007 at 01:22 PM

Loading Primary Sales Histoiry - Strategy required for 7 crore records


Dear Gurus,

I need to load primary history data from legacy system based on oracle. The records could be around 7 crores. I would like to know the stragegy to be established before loading the data into BW. Please let me know the advantages/disadvantages of flat files over DB connect and db connect over flat files. It would be great if you can suggest me strategy to be followed before i start establishing the load procedure.

Thanks and Regards