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 production issues in datastage?
What is the difference between round-robin partitioning and hash partitioning?
Identifying the bottlenecks in various components of Informatica and resolving them.
When do we go for the tools in the market?
Explain me ETL project architecture in Detail?
Do we need an etl tool?
how many maximum session supports to multiload in teradata ??
What is partitioning? Explain about round-robin, hash partitioning.
What is the difference between project backlog and product backlog?
Can u access a repository created in previous version of Informatica?
What is abap? What are idocs?
Compare etl & elt?
What is lookup table in etl testing?
what is Forward,Reverse and Re_engineering?
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?