DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
IBM Cognos BI
|
|
|
Excel
|
|
|
Informatica PowerCenter
|
|
|
. None of the above
|
Detailed explanation-1: -Informatica PowerCenter is an ETL tool that is used to enterprise extract, transform, and load the data from the sources. We can build enterprise data warehouses with the help of the Informatica PowerCenter.
Detailed explanation-2: -Informatica PowerCenter is a widely used extraction, transformation and loading (ETL) tool used in building enterprise data warehouses. The components within Informatica PowerCenter aid in extracting data from its source, transforming it as per business requirements and loading it into a target data warehouse.
Detailed explanation-3: -Informatica Developer Client tool is used to design and implement data integration, data quality, data profiling, data services, and big data solutions. It is a thick client and comes with an installer package to be installed on the machine. It is used to import metadata, create connections, and create data objects.