Qlualify * ;

[#1]

Hey guys

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

Qualify *;

unqualify *;

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

Gloria

[#2]

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.

[#3]

Hi there

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

Cool~

Gloria