topic Effective way of using Resident Load? in QlikView

Effective way of using Resident Load?

Thu, 17 Dec 2009 20:57:44 GMT

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

Effective way of using Resident Load?

Anonymous — Thu, 17 Dec 2009 21:10:44 GMT

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.

Effective way of using Resident Load?

Thu, 17 Dec 2009 21:53:40 GMT

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;

Effective way of using Resident Load?

Thu, 17 Dec 2009 21:54:52 GMT

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