Data Modelling

[Anonymous]

Hello,

Need a small help in Data Modelling....

I am working on a data model where most of the tables are having one common field say ID which can create looping in model.

For example say:

Table1,Table2,Table3 is having ID and they are interlinked(One field into multiple table) with each other.

I tried for Composite Key as well but their is no other common field so that my Table1 is linked to Table2 with a unique key and my Table3 is linked to either of the Table1 or Table2 by a another unique field.

So, is there any way to do this kind of modelling when you are having only one common field in multiple tables???

Thanks in advance.

Regards,

Balraj Ahlawat

[Anonymous]

I dont think that if only one field is in common in all tables then there will be any loop,

I think , according to below image , model would be created....

if this does not help then please elaborate more on your issue for better understanding..

[Anonymous]

Nitin,

Thanks for Immediate response.

Same thing I am getting....

Just want to check is this good for data modelling??

Regards,

Balraj Ahlawat

[sujeetsingh]

Of course

[sujeetsingh]

Go to this doc

Best Practices for Data Modelling

[senpradip007]

Can you share your data model?

[Anonymous]

Thanks Sujeet.

[Anonymous]

Thanks for sharing very useful document

anant

[its_anandrjs]

You can try with this code also

Suppose there is scenario then us unqualify function for this.

QUALIFY *;

UNQUALIFY ID;

LOAD * INLINE [

    ID, Field1, Field2, Field3

    1, 2, 3, 4

];

LOAD * INLINE [

    ID, Field1, Field2, Field3

    1, 2, 3, 4

];

LOAD * INLINE [

    ID, Field1, Field2, Field3

    1, 2, 3, 4

];

[Anonymous]

Pradip,

Nitin have already given the model....

Regards,

Balraj Ahlawat