Q1
Q1. WHAT IS ETL? Which are the ETL Tools available in market? What is BI and which are BI tools?
ANS: ETL stands for Extract , Transform and Load. ETL tools are used to transform the data from source(files or tables) to load the target (tables or files). Generally, in data from data warehouse is used for analytical processing and that data is used in bi reports, so that the business should take the necessary actions using bi reports.
Below ETL tools are available in market
Informatica Powercenter
IBM DataStage
Ab-Initio
Big Data pipeline(HDFS,HIVE,PYSPARK, SCOOP are used )
BI Stands for Business Intelligence. The data from DWH is used to populate reports and dashboards so that business can take actions using the data from reports. ex: which car is popular in people and how much demand of that car so that production of that particular car should be increase or decrease as per demand.
Popular BI Tools:
Cognos
QlikView
Tableau
Power BI