Hai All,
I have two source systems one is R/3 and other DB where I am get data to BW.
1. <b>Is it a good idea to bring in all the data thats available in source system to ODS </b> and then take what ever I need into another ODs and work with that
or
2. <b>Make a view and filter the dat in the source system itself to get only the required information?</b>
The problem is there are some standard extractors also.
I know this is more of a system specific question and depends on volume of data. But what is a good practise the first ot the second?
Thank you.
Message was edited by: Visu Venkat