Properties:
if u select distinct eliminate duplicates
case sensitive valid for strings to sort the data
null treated low null values are given least priority
A data warehouse is a copy of transaction data specifically structured for Querying and Analyzing and Reporting. Prefer Informatica to do the ETL process, because Informatica is more powerful in designing and building data warehouses. It can connect to several sources and targets to extract meta data from sources and targets, transform and load the data into target systems.
if u select distinct eliminate duplicates
case sensitive valid for strings to sort the data
null treated low null values are given least priority
No comments:
Post a Comment