3NF layers in HANA Cloud

[former_member773218]

Hi All,

Two Topics: 1. 3NF layers in HANA Cloud 2. Implementing SDQ on complex data flow.

#1. Please give your inputs on "How to Build 3NF" in HANA Cloud.

1a) We have several source systems (naming few: Sales Force, SQL Server, MySQL and S4 On Premises), using SDI we will load data in HANA Cloud. Next we need to build a 3NF layer on top of landed (Staged Data).

Please suggest How to build 3NF layer or Why we need to go with 3NF or Do 3NF layer really required? We're not sure whether we're going the right route.

1b) Are there any Modeling Tool (like ERwin) to support the Graphical View of Building the Tables and Relationship in HANA Cloud?

#2. How to Implement SDQ for multiple complex sources. Please share some documents who already implemented the SDQ for multiple sources.

Summarize my Question: How to build a Data Model for Several Source Systems in HANA Cloud. Kindly give your Architectural (what goes in Staging Layer, Data Layer, Transformation Layer and Reporting Layers) thoughts and expertise.

Thanks in advance.

Out of Topic not expecting answer for the below, just sharing.

#1a) Tried with a sample SQL code but not supportive.

Create or "Replace" Table is not working

[former_member751591]

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with Community Q&A , as it provides tips for preparing questions that draw responses from our members.

For example, you can:

- outline what steps you took to find answers (and why they weren't helpful)

- share screenshots of what you've seen/done

- make sure you've applied the appropriate tags

- use a more descriptive subject line.

The more details you provide, the more likely it is that members will be able to respond. Feel free to also take our Q&A tutorial Q&A tutorial

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your Profile you encourage readers to respond.