Loosely Couple Table

[nihhalmca]

Hi All,

When will we use 'Loosen' keyword in edit script.

How it is useful for data modeling. Which scenarios Loosely couple table will use.

Can anybody give examples on this.

Thank you.

Regards,

Nihhal.

[PradeepReddy]

go through the link...

Re: How to "Loosely Couple" a Table?

[#3]

Hi,

If you have circular reference in your data model in this case u can use loosen tables.

suppose if you have circular refference between A,B,C

then use this command in the script after load statement of all the tables.

Loosen tables A,B,C;

it will give good performance if you have circular refference also

[nihhalmca]

Hi Rakesh,

Thanks for response.

Can you give share sample qvw.

[jagan · Accepted solution]

Hi,

Check this

Table1:

LOAD

*

INLINE [

A, B

1, 2 ];

Table2:

LOAD

*

INLINE [

C, B

1, 2 ];

Table3:

LOAD

*

INLINE [

C, A

1, 2 ];

Loosen Table Table3;

By using Loosen Table Table3; you won't get the error message regarding the circular loop.

Regards,

Jagan.

[Colin-Albert]

If you have "Loosley Coupled" tables, and a circular reference then your data model is incorrect and you should fix the problem by correctly linking the tables.

Using "Loosen" is not a fix for an incorrect data model.

[#7]

Hi,

Sorry I Dont have any sample application for loosen concept.

[nihhalmca]

Its Ok Rakesh.

[jagan]

Hi Nihhal,

Having Loosely coupled tables is not a good practice to avoid Circular loop issue, it is a quick fix but not the efficient one.  Try to avoid loop by using various techniques like Link Table, Concatenate, Renaming field etc.

Hope this helps you.

Regards,

Jagan.

[nihhalmca]

Hi All,

Just check Loosely couple option after followed by Jagan mohan answer (shown as correct answer). see below steps to check Loosely couple option.

Settings -- Document properties -- table -- check Loosely couple option for required table.

Regards,

Chittibabu.