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