Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This is the scenario
Table1:
Load
EMP_Id,
EMP_Name
SQL Select
emp_id,
emp_name
from employee;
temp_tabe:
load sal,emp_id
resident salry;
Table3:
load address
emp_id
resident table1;
The case is need to merge all the tables.
Table1:
Load
EMP_Id,
EMP_Name
SQL Select
emp_id,
emp_name
from employee;
join(Table1) load
emp_id as _EMP_Id,
sal
resident salry;
join(Table1) load
emp_id as EMP_Id,
address
resident ???;
Table1:
Load
EMP_Id,
EMP_Name
SQL Select
emp_id,
emp_name
from employee;
join(Table1) load
emp_id as _EMP_Id,
sal
resident salry;
join(Table1) load
emp_id as EMP_Id,
address
resident ???;
Then will it create synthetic keys for emp_id?
No it will not create the Synthetic key ...