Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlualify * ;

Hey guys

A quick one: in script, what is the meaning of

Qualify *;

unqualify *;

Thanks a lot~~~~~~~~~~~~

Gloria

2 Replies
Not applicable
Author

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.

Not applicable
Author

Hi there

Thank you so much!! the example is understandable!!

Cool~

Gloria