Oracle Extract transform load (ETL) Question: Download Questions PDF
Do we need an ETL tool? When do we go for the tools in the market?
![Oracle ETL Interview Answer Oracle ETL Interview Question](https://globalguideline.com/public/images/interview/6.png)
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 Oracle ETL Interview Questions And Answers
PDF
Previous Question | Next Question |
How to determine what records to extract? | Can we use procedural logic inside Infromatica? If yes how, if now how can we use external procedural logic in informatica? |