For data warehousing, you can do more sophisticated transformations in this way than you canwith simple datatype conversions. You can also use this mechanism in data warehousing to do data cleansing.While external tables cannot contain a column object, constructor functions can be used to build a column object from attributes in the external table