synthetic keys

[raadwiptec]

i have 2 tables

Table 1

============

ID

Month

Year

.Prices.

..

Some additonal colums

I Store table 1 in QVD format as table2.qvd  each month as back up for reference...as the actual Table 1 changes its prices end of month and it would further change all the data with in table 1 irrespective of month

Now I take the data from table2.qvd and display it in a chart from the back up qvd/s

The issue here is i have a common list box for Month and year. so when iam loading table 2 synthetic is getting formed. for month and year................................

[adamdavi3s]

have a check on here for canonical dates  and/or link tables as this should help solve your issue.

There should be plenty of of answers to help.

[Anonymous]

can you concatenate table2 into your existing table?

then no syntetic key will be created

and fro mour description I assume that the data is not overlapping

(different months)

The name of your fields remain same in Table2?

[raadwiptec]

how do we concatenate just 2 columns month and year?

[adamdavi3s]

year&'-'&month

something like that in your load script will do it

[Anonymous]

can you explain more in Detail? what do you store in Table2.qvd?

as Prices Change every month you would need to store Prices and id as well in table2???

and then you Need to load all 4 fields again

as you wrote you get syntetic key for year and month only?

can you post your script and explain why you only load year and month