Use Concatenate or Link Table?

[marcohadiyanto]

hi,

i have this table viewer with sync Table and Loop, what should i do? use link table or concatenate?

thanks,

[sunil2288 · Accepted solution]

Hi,

You better use join as Concatenation is permissible when two tables has same domain data.

here Insurrance Asset and prodcut offering are two different Entoty showing different data.

Regards

Sunil

[marcohadiyanto]

thanks for your quick reply,

so, what do you mean use join better than Concatenation?

[marcohadiyanto]

hi sunil,

it's better doing join table not Concatenation,

thanks

[sunil2288]

HI,

Have you ever used Inner join Or Concatenation on two tables...

Joining of two tables is normal join as SQL.

But Concatenation means adding new data into an existing table...

Regards

Sunil

[sunil2288]

HI,

Have you ever used Inner join Or Concatenation on two tables...

Joining of two tables is normal join as in SQL.

But Concatenation means adding new data into an existing table...

Regards

Sunil

[marcohadiyanto]

hi sunil

thanks for your reply . I'll check it first.

[qliksus]

Its always better to create a Linktable when you similar field in 2 or more table. Now you have to create a LinkTable which contain all similarfield name and key from the tables and make linking key from Linktable fields and join with the child table. All similar fieldname table should connect to Linktable not with eachother.

[sunil2288]

Hi Susant Bhai..

How are you...M In mumbai now.

Will you please tell me Is Link table same as fact table in Datawarehousing..

Regards

Sunil

[qliksus]

No both are not same. fact table contains all Trancation details and from there link goes to dimension table. But Link table contains all similar field .

When u are working with Warehouse data (which contain dimension and fact) then linktable is same as CommonFact table.