Avoiding circular loop in the datamodel

[divya_anand]

Hi All,

I am working with a complex datamodel and just to give you an idea I am highlighting in the below picture only the areas of interest in the datamodel. As you can see, the tables are connected as shown with various keys. All these connections are important. Now I have 2 fields (C & D in this case) which is basically the CodeNo & has to be linked. So, clearly that would create a circular loop and joining or concatenating tables (Table1, Table2, Table3, Table4) is not an option for me for this datamodel.

Any other idea that clicks your mind? Please let me know.

Thank you.

[swuehl]

That's hard to answer without knowing your data model and requirements in detail.

You probably know that you can keep both fields unlinked, if they mean something semantically different, as discussed in

Circular References

Then just rename CodeNo in one of the tables.

[prat1507]

Hi Divya

Table1 is already linked to Table4 in the data model given. You can rename the field D which is CodeName as something else. I think they would still be linked as per the fields you've used in your data model.

Regards
Pratyush

[divya_anand]

Hi Stefan,

Thank you for the response. I agree that it's difficult to answer such questions without QVW.

I'll try to work around the logic mentioned in the link you provided.

Thank you.

[divya_anand]

Hi Pratyush,

Thank you for the response.

I understand your point, that's what I thought too when I saw the datamodel. But the datamodel I am dealing with seems very different.

Anyways, Let me try this out and see.