Informatica – ETL testing -Challenges

Much ETL testing these days is completed by SQL scripting or “eyeballing” of knowledge on spreadsheets. These approaches to ETL testing are terribly long, and rarely give complete take a look at coverage. Informatica knowledge Validation possibility provides Associate in Nursing ETL take a look acting tool which will accelerate and modify ETL testing in each production environments and development & test. This means that you simply will deliver complete, repeatable and auditable take a look at coverage in less time with no programming skills needed.

ETL-Testing view imagesETL Testing Use Cases

  • Production Validation testing (testing knowledge before getting in production). Generally referred to as “table balancing” or “production reconciliation,” this kind of ETL testing is completed on knowledge because it is being moved into production systems. The info in your production systems has got to be right so as to support your business deciding. Informatica knowledge Validation possibility provides the ETL testing automation and management capabilities to confirm that your production systems don’t seem to be compromised by the info update method.
  • Source to focus on Testing (data is transformed). This kind of ETL testing validates that information values when a change are the expected data values. The Informatica knowledge Validation possibility encompasses a giant set of pre-built operators to create this kind of ETL testing with no programming skills needed.
  • Application Upgrades (same-to-same ETL testing). This kind of ETL testing validates that knowledgecoming back from Associate in Nursing older application or repository is precisely an equivalent because the data within the new application or repository. Should of this kind of ETL testing are often mechanically generated, saving substantial take a look at development time?

Informatica could be a powerful ETL tool that supports all kind of extraction, transformation and cargo (ETL) activity. Informatica encompasses an easy visual interface, in order that user will use any kind of supply for extracting knowledge and cargo the info in desired format like info files etc.

Informatica Power center Components

  • Repository- power center repository forms the middle of this suite wherever data tables are often created inside the info of power center. Each the server and consumer of power center will access and retrieve those data.
  • Repository Server- employed in order to manage and continue swish association between the consumer applications and also the server. It helps in winning and change the tables and provides consistency of knowledge object.

InformaticaClient- Power center consumer performs functions together with management of users and process their supply and targets, creates and style mappings and later modify the work flow consistent with that.

  • Server- Power center server is that the one that extracts information and performs transformation and later hundreds the reworked data into their desired targets.

1 Comment

  1. raju

    Great Post Xoom, Short and to the point, Alwaays good to have these Pieces of Information in your back pocket just incase it comes up on your site someday

    Reply

Leave a Comment

Your email address will not be published. Required fields are marked *