Can you advise with it?

Robert Angel

Yes, looks good to me!

Assuming it reflects your data architecture?!

Alex Sharkov

Hmm after your words  i begin hesitate

So Partner(Client) has Accounts. From this Accounts Parther do Payments. That's all architecture.

I realy could not understand why we need divide fact & dim on phisical layer.. for a while.

Robert Angel

Hi, you might want to have a read of 'kimball data warehouse methodology'.

You might also want to get yourself on an advanced rpd modelling training session from a reputable Oracle partner or Oracle University.

If you question is answered then could you kindly close this question for the benefit of others.

If you are feeling generous then use 'Mark as Answer', if not then use 'Close Assumed Answered' - leaving them open means others waste time trying to help you on a question you are done with.

[Deleted User]

Robert Angel wrote:You might also want to get yourself on an advanced rpd modelling training session from a reputable Oracle partner or Oracle University.

Not sure what to say to that X-D

Robert Angel

I may be biased but I used to deliver the training (and update it) when I was working for an Oracle Partner, feedback was generally very good as we were also consultants / implementors / developers / architects (bring your own brush)

I got mixed feedback from people who went on the OU course directly from Oracle.

And no slight intended but from some of the OPs questions it did seem like he was struggling with some of the basics.

[Deleted User]

But that's just it. It's the trainer. The actual person. Not the "Partner".

I used to give courses for OU and other Partners as well. Feedback always was extremely different depending on which person gave the course.

Robert Angel

Point taken and totally agree.

The difference between following a script and providing zero added value OR actually having insight and being able to field questions and suggest better alternatives.