Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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