Effective way of using Resident Load?

[#1]

Dear Friends,

I have the three below tables

DIM		Fact		FILE
ID		ID		REGION
REGION		GROSS_SAL		EXPENDITURE_AMT
CITY		MONTH_SAL		DUE_AMT

I have already data model where DIM and FACT joined with ID.

Now i want to bringup columns REGION,EXPENDITURE_AMT and DUE_AMT into FACT from FILE and want to join Fact using ID,REGION with DIM table ID,REGION.

I know this can be achieve through CONCATINATE and RESIDENT together.But problem is i Dont want to load Fact twice.I have 20 MM records in the Fact.

It;s okay if you load FILE twice. Please provide me the solution as per my requirement.

Regards,

Ram

[Anonymous]

Resident uses the data already loaded in memory ... you don't actually load Fact twice.

Do you use the FILE table for anything else?? If not you can do the load when concatinating.

[#3]

I am doing like this

FACT:

Load

ID,

GROSS_SAL,

MONTH_sAL

FROM Fact.qvd;

CONCATINATE

LOAD

(ID&REGION) as "%Join",

REGION,

EXPENDITURE_AMT,

DUE_AMT

FROM FILE.qvd;

[#4]

He i am getting the errow like ID doesn't exists error. Because ID doesn't exists in File.qvd