what are the different Reporting and ETL tools available in
the market?
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 are the etl testing operations includes?
What is grain of fact?
what are the data modeling tools you have used?(polaris)
Explain etl?
flat filevalidation in informatica
What are the names of the layers in etl?
What is tracing level? How many types of transformations supported by sorted input?
Give the benefits of data integration suite?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
What is etl process? How many steps etl contains?
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
What is partitioning? Explain different types of partitioning?
What is data modeling and data mining?
explain the methodology of Data Warehousing?(Polaries)
what is the difference steps for data modeling?