Oracle Extract transform load (ETL) Question: Download Oracle ETL PDF
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).
| 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? |