Precedent Load vs Resident Load

Thu, 27 Dec 2012 14:41:08 GMT

please any one can explain

Precedent Load vs Resident Load?

Thanks in advance....

jagan — Thu, 27 Dec 2012 17:53:46 GMT

Hi Nagaraju,

Preceding Load:

Loading data from already load statement is called preceding load. For example

LOAD //This section is called preceding load

Month(Date) AS Month,

Year(Date) AS Year;

LOAD // Normal load.

Department,

Date,

Sales

FROM DataSource;

Resident:

Data loaded from already loaded table is called Resident table.

For example

TableName:

LOAD

FROM DataSource;

Data:

LOAD //Resident Load

Month(Date) AS Month,

Year(Date) AS Year

RESIDENT TableName;

Hope this helps you.

Regards,

Jagan.