transaction data..........masterdata

[Former Member]

hai to all,

here is some text for all

is it possible to load Transaction data with out master data? if possible which is the best method among the following two in the scope of performance.

<u>loading transaction data with master data

loading transaction data without master data </u>

if loading transaction data without master data is not better pl give the reason (in the scope of performance)

[Former Member]

Hi Shyam,

Just imagine you want a employee report with emp id, name, dept id, dept name, emp address, salary.

Now if you were to load the transaction data without master data then you load all the above mentioned data as transaction data.

Now for the same example if you load transaction data with master data then you load Emp Id, Dept Id and Salary as transaction data. You would load Emp Name, Emp Address as Attributes of Emp master data.

What is illustrated is a small example. In real time you would need many more attributes. You would not be able to load all of them with the transacton data.

Hope I have made things clear.

Bye

Dinesh

(Do not forget to assign points!!.)

[Former Member]

Hi Shyam,

Yes. It is possible to load transaction without master data. (Hope you would know that the transaction data contains characteristics data + Key figures).

But the whole idea of data modelling(using star schema) would be defeated if you are loading transaction data without master data. Just imagine how the performance would be!!.

Bye

Dinesh

Message was edited by: Dinesh Lalchand

[Former Member]

hai denish

But the whole idea of data modelling(using star schema) would be defeated if you are loading transaction data without master data. Just imagine how the performance would be!!.

i want more clarification

thanx

venkat/shyam

[Ashwin]

Hi!

assume.. if there is no information about customers(Master Data), But you have loaded information about all the orders in past months (transaction data). so there will be a field customer in the orders which will be a customer no.

how can you verify who is the customer using the customerno because there is no master data. So loading only transaction data does not provide you any meaning in the reports.

with regards

ashwin