2 Replies Latest reply: Nov 14, 2012 8:31 PM by gloria-melbourne RSS

    Qlualify * ;

      Hey guys

       

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

       

      Qualify *;

      unqualify *;

       

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

       

      Gloria

        • Re: Qlualify * ;

          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.