Resident load and preceeding Load in Qv

Wed, 11 Dec 2013 07:12:16 GMT

Hi ,

Can any body give complete differences with example about preceeding load and resident load.

give me with examples and tell where we should go for resident and where we should go for preceeding.

Re: Resident load and preceeding Load in Qv

Wed, 11 Dec 2013 08:38:02 GMT

Loading Data from an already loaded Qlikview table(Data in RAM) is the Resident Load.

This load is used to do transformations to the already loaded data.

If you going to pull data from a system say Salesforce, SAP you would just pull the raw data without any transformations else you are going to hit the performance.

So once the data is available in the RAM, you can apply any tranformations to it.

Eg:

Employees://Pulling from Database

Select
Empname,
HireDate,
Salary,
Incentives
From Employee;

Emp://Pulling from Already loaded data
Load Empname,
Month(HireDate),
Salary + Incentives as ‘GrossSalary’
Resident Employees;

Preceding load is same as Resident. We can write the example as,

Employees://Pulling from Database

Load Empname,

Month(HireDate),

Salary + Incentives as ‘GrossSalary’;

Select
Empname,
HireDate,
Salary,
Incentives
From Employee;

Regards,

Prabhu

Re: Resident load and preceeding Load in Qv

hic — Wed, 11 Dec 2013 08:44:36 GMT

HIC

topic Resident load and preceeding Load in Qv in QlikView

Resident load and preceeding Load in Qv

Re: Resident load and preceeding Load in Qv

Re: Resident load and preceeding Load in Qv