Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey guys
A quick one: in script, what is the meaning of
Qualify *;
unqualify *;
Thanks a lot~~~~~~~~~~~~
Gloria
Qualify is a keyword that is used to 'qualify' the field names with the tablename. If you have something like:
Qualify *;
Unqualify EmpID;
Employees:
Load
EmpID,
FirstName,
LastName
From <source>
will result in
Employees.FirstName
Employees.Lastname
and since you Unqualified EmpID it will remain EmpID. - and will not be Employees.EmpID
You can use EmpID as a key to link the Employees dimension to the fact table in your data model.
Hi there
Thank you so much!! the example is understandable!!
Cool~
Gloria