Interested to Buy Any Domain ? << Click Here >> for more details...
what are the different Reporting and ETL tools available in
the market?
- 3 Answers
- 13031 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 pmrep command?
What is lookup table in etl testing?
what is the main role of FI on business
When do we analyze the tables?
How to delete data which is not in source table?
list and discuss two approaches for updation of target table in Informatica and how they are different.
Explain the difference between etl tool and olap tools?
can cubes contain measures ?
what are the concerns of OLTP and DSS systems?
how do u extract data from different data sources explain with an example?
Explain what is etl process? How many steps etl contains explain with example?
What is a lookup table in etl?
List few etl bugs?
what is the difference between cubes and package in cognos
where is the cache (lookup, index) created and how can you see it.
