How to do residential loading without dropping the existing table.

[yzhang88]

For example, I have a detail table that join two qvds, then want to get a summary table by group by .

Details:

Load

......

from QVD A

left join QVD B;

Summary:

Load

sum(field A),

sum(field B)

.....

Resident Details

Group by fieldC, fieldD;

Can I keep both Details and Summary tables in final data model? Thanks.

[vamsee]

Yes, you can but make sure they are connected by only one column else you will have synthetic keys.

[maxsheva]

As Vamsee already mentioned you may keep both tables.

Just be sure you don't have more than one field with common name.

You may look at qualify statement or can assign alias manually.

[marcus_sommer]

Take a look here: Fact Table with Mixed Granularity

- Marcus