what are the different Reporting and ETL tools available in
the market?
- 3 Answers
- 11989 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
Which transformation we use to convert 'NA' to 'Not Available'
tell me few points when u become TL
Explain the use lookup tables and Aggregate tables?
What is the difference between Data Warehousing and Data Mining?
When do we go for the tools in the market?
What is fact? What are the types of facts?
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
How can we use external procedural logic in informatica?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
How many types of transformations supported by sorted input?
When do we analyze the tables?
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
What is etl process. How many steps etl contains explain with example?
how do u identify the changed records in operational data?
Explain about hash partitioning?
