1 / 17

ETL ity

ETL ity. Speed up your ETL development! faster time to market guaranteed quality fix price development. ETL ity - generate Quality. ETL ity supports your work with INFORMATICA PowerCenter .

neka
Download Presentation

ETL ity

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. ETLity Speed up your ETL development! faster time to market guaranteed quality fix price development

  2. ETLity - generate Quality • ETLitysupports your work with INFORMATICA PowerCenter. • ETLityis the fastest and most inexpensive approach for generating arbitrary numbers of similarly structured mappings. • Your Benefit is a reduction of the original • development effort up to 99% • time up to 99% • save a significant amount of money 300 Mappings, each 2 days = 600 days using ETLity : 5 days ≙ 1%

  3. ETLity - generate Quality • ETLity generates mapplets, mappings, sessions, workflows, parameter files and SQL scripts bases on your requirements. • ETLitysupports agile approaches. You can enrich your mappings in a later project stage. • ETLityis used in 3 simple steps: • Example • Template and Scope • ETLity code generation

  4. The example is made with Powercenter. • It is fully functional and represents your ETL logic • including all objects you want to generate. 3 Steps Example • The template is based on the example and is a generalized representation of your ETL logic. • It is also made with Powercenter. • You can also benefit from our template stock (e.g. with full delta detection and complete history). Template • ETLity generates the requested files based on the Template and your generation scope (the source tables you want to load). • You can import the generated XML-files into your Informatica Repository. You can simply copy the parameter files to the required location and run the SQL files against your database. ETLity

  5. Demo: pass-through mapping Example Template scope: departments ETLity

  6. Demo: pass-through mapping ETLityWorkbench Wfl Template Mapping Template Source Table Columns Alias Data type scope: departments

  7. Demo: pass-through mapping Example Template ETLity

  8. ETLity Use Case ‘Full History’

  9. Use Case ‘Full History’

  10. Use Case

  11. Use Case

  12. Use Case

  13. Use Case

  14. Use Case

  15. Use Case

  16. Use Case

  17. ETLity - generate Quality Find out more! Web: www.ETLity.de Email: info@etlity.de

More Related