topic Re: need suggetion regarding data model in QlikView

need suggetion regarding data model

Wed, 05 Aug 2015 02:18:53 GMT

hi all,

In My Datamodel i have two tables one table contains the sales represent details the second table contains sales represent performance details the thing is 4 fields common between both tables when i load the data and then run synthetic table was formed

to remove that synthetic table which approach is best

1.join two tables or

2.by using qualify for three fields except key field or

3.remove common fields from one table except key field

here data is same for 4 fields in two tables

Thanks

Re: need suggetion regarding data model

vardhancse — Wed, 05 Aug 2015 02:30:15 GMT

Hi,

Joining the tables using the four common fields will be helpful.

Or Else

Any way the data is same for 4 fields in both the tables even we can remove 3 fields and can join based on one key

Re: need suggetion regarding data model

sunny_talwar — Wed, 05 Aug 2015 02:30:52 GMT

I would go with 1st or the 3rd option. If key fields repeat in any of the two tables, I would stick with 3rd option, else there is no harm in joining them together too. I don't see a benefit of Qualifying them and creating another field with the same information available in another field.

HTH

Best,

Sunny

Re: need suggetion regarding data model

Wed, 05 Aug 2015 06:39:09 GMT

Dear,

In your senarios, in term of DW its showing many to many relationship between two tables so option 1 is best for it.

Else if you want to analyis your information separate or combinde so option 3 is best, make concat 4 columns as composit key and join (associate) both tables.

Regards,

Zain.