Skip to Content
0
Former Member
Nov 04, 2005 at 05:02 PM

Data modeling question

25 Views

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