ETL (Extract, transform, load) Question: Download Questions PDF
Explain Do we need an ETL tool? When do we go for the tools in the market?
Answer:
ETL Tool:
It is used to Extract(E) data from multiple source systems(like RDBMS,Flat files,Mainframes,SAP,XML etc) transform(T) them based on Business requirements and Load(L) in target locations.(like tables,files etc).
Need of ETL Tool:
An ETL tool is typically required when data scattered accross different systems.(like RDBMS,Flat files,Mainframes,SAP,XML etc).
It is used to Extract(E) data from multiple source systems(like RDBMS,Flat files,Mainframes,SAP,XML etc) transform(T) them based on Business requirements and Load(L) in target locations.(like tables,files etc).
Need of ETL Tool:
An ETL tool is typically required when data scattered accross different systems.(like RDBMS,Flat files,Mainframes,SAP,XML etc).
Download Extract, transform, load (ETL) Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Explain What is partitioning? What are the types of partitioning? | Explain What is Informatica Metadata and where is it stored? |