Precedent Load vs Resident Load

[#1]

please any one can explain

Precedent Load vs Resident Load?

Thanks in advance....

[jagan]

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.