Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Precedent Load vs Resident Load?
Thanks in advance....
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.