IBM InfoSphere, product family for your IT family!
July 02, 2018
IBM InfoSphere, product family for your IT family!
Score 8 out of 10
Vetted Review
Verified User
Modules Used
- InfoSphere DataStage
- InfoSphere Data Architect
- InfoSphere Information Governance Catalog
- InfoSphere Information Analyzer
Overall Satisfaction with IBM InfoSphere Information Server
We use infosphere for
1-Load Data Warehouse: I design ETL jobs for load data to our ODS, DWH and DM tables
2-Design DWH with Data Architect: I use data architect for creating DWH and DM tables. Create diagrams for business flow, table relationships etc.
3-Analysis to OLTP with Information Analyser: I use IA to check our OLTP system.
4-Information Governance Catalog: see the big picture of business and infostructure. We use IGC as a data dictionary, data lineage, and business lineage tool.
1-Load Data Warehouse: I design ETL jobs for load data to our ODS, DWH and DM tables
2-Design DWH with Data Architect: I use data architect for creating DWH and DM tables. Create diagrams for business flow, table relationships etc.
3-Analysis to OLTP with Information Analyser: I use IA to check our OLTP system.
4-Information Governance Catalog: see the big picture of business and infostructure. We use IGC as a data dictionary, data lineage, and business lineage tool.
Pros
- IIS best for ETL ,not ELT , and many and diffrent source systems.
- It also can process big data , unstuctured data
- It is not only DWH , you can use infosphere for analys and see the bigger architecture of your OLTP systems
Cons
- Infosphere may improve its logging system. If you dont familier logs of infosphere it's little bit hard to understand
- If you don't use all of the product family, it will be expensive. But if you want to plan use all the products and you will position it in the center of your infrastructure ROI will be effective.
IBM InfoSphere Information Server Feature Ratings
Comments
Please log in to join the conversation