what are the different Reporting and ETL tools available in
the market?
- 3 Answers
- 12190 Views
- I also Faced
- E-Mail Answers
Answer Posted / katelynthomas
ETL Tool is used to get data from many source system like RDBMS, SAP, etc. and convert them based on the user requirement. It is required when data float across many systems. Abinitio,DataStage, Informatica, Cognos Decision Stream, etc
ETL is extraction , transforming , loading process the steps are :
1 – define the source
2 – define the target
3 – create the mapping
4 – create the session
5 – create the work flow
ETL Tool is used for extracting data from the legecy system and load it into specified database with some processing of cleansing data.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is initial load and what is full load?
what is the use of structures?how many nodes can u create in a structure?
What are snapshots?
can cubes contain measures ?
what are the production issues in datastage?
what are the cubes developed in a sap bw project and what is the requirement for developing it?
What are the differences between sql override and update override?
What is etl process. How many steps etl contains explain with example?
What is staging area referring to?
what is session partitioning?
In Which Transformation We Can Use Having Clause In Informatica?
Explain what are the various etl tools in the market?
what is pmrep command?
explain the methodology of Data Warehousing?(Polaries)
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
