Sunday, September 11, 2011

Data Cleansing in Universe


DATA CLEANSING CONCEPT IN UNIVERSE:
----àClick on Insert Menu
----àObject
----àName the Object
----àType----character
  Place the cursor in Select
----àClick on Browse
----àFrom Functions area------Expand character
----àDouble click on Ucase Function.
----àExpand Tables and Columns
----àDouble click on Month name
 The expression is applied as Ucase (Table name. Column name)
----àClick on Parse
If Parsing is Ok ----Click on Ok

No comments:

Post a Comment