Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Please advise best data model design from requirement gathering.
thanks in advance.
1.Study the data sources thoroughly .
2.Load required fields and tables only.
3.Rename the fields if required.
4.Take care about Circular loops, SCD and Synthetic keys(If required).
5.Apply Transformation where ever it is requires.
this is quite an open question. What exactly are you looking for?
how to start data model design?
To understand the Data model design first understand the Schema like Star/Snowflake schema. What is normalization and denormalization. There are lot of documents on the community you can go through it.
1.Study the data sources thoroughly .
2.Load required fields and tables only.
3.Rename the fields if required.
4.Take care about Circular loops, SCD and Synthetic keys(If required).
5.Apply Transformation where ever it is requires.
Hi,
See the attachment.
Thanks,
AS