nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

How to join two facts.

Chaitanya

Hi Team,

Recently, I have attended couple of interviews. In Each Interview, they are asking How to Join Two Facts? I said, No.we cannot join. But they are asking if requirement comes like this, how can you do it?

Can anybody please answer this question with steps?

Regards,

Find more posts tagged with

Accepted answers

All comments

Thomas Dodds

I'd reply: How would such a requirement after being vetted and agreed upon ever get passed to a developer? A request is not a requirement ... the issue is not 'how?' (that's easy join the keys where the granularity matches) - but the 'why?' (the rules of dimensional modeling are thrown out)

YOU are interviewing them too ... do you really want to do development work for people who would disregard the rules of modeling to have you implement/develop things in a tool that is based on those very same rules? "Go where you will be celebrated" - is often a moniker of HR and recruiting -- apply it to you. Celebration of your skill implies adherence to the common knowledge base you and they share (namely: dimensional modeling).

Joel Acha

Martin van Donselaar

Hth,I would appreciate if you mark our answers as such! :-)