Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
The below script has me confused. Could anyone answer the following questions:
1) How do you know which table is left and which is right?
2) What does the statement RESIDENT [Main Data] do?
Thanks!
Temp_Aircraft_Type_Dim:
RIGHT KEEP ([Destination Airports])
LOAD DISTINCT
[%Destination Airport ID]
RESIDENT [Main Data];
DROP TABLE Temp_Destination_AirportID_Dim;
1. the table loaded earlier (Destination Airports) is left, the table loaded later (Temp_Aircraft_Type_Dim) is right.
2. Loading data from the previously created (in the script) logical table (Main Data)
RESIDENT, from online help
resident is used if data should be loaded from a previously loaded table
KEEP
image is from here
hi Alexander,
RESIDENT is key word means from RAM.
suppose we load the table example Employee and stored locally named as Emp.
then we want to reuse the fields presented in the Emp then we simply load from RESIDENT Emp instead of again going to getting from the Db or source .
Understanding Join, Keep and Concatenate
above link will help ful to u understanding keep,join and concatenate.
i hope it helps you.
regards
Mahesh T.
Thanks Michael. That was helpful.
you are fine with answers can you please close the thread by correct answer and helpful etc.it will be helpful to other people as well.
regards
Mahesh T