vmware training

1
Informatica ETL TRAINING
For More Details Email info_at_globalonlinetrain
ings.com IND 914060501418 UK 44(0) 203 371 00
77 What's app 1 516 8586242 Visit
www.globalonlinetrainings.com

2
GLOBAL ONLINE TRAININGS

• Global Online Trainings has proven track record
  of delivering successful trainings on various
  technologies globally to improve the bottom line
  of the business for competencies of the corporate
  and careers growth of the individuals
  consultants.
• We are providing best online training center that
  provides you training on all modules of SAP,
  Oracle, SAS, PHP and Testing Tools, Data
  Warehousing, PLSQL and SQL. our professional and
  efficient team of trainers brings out their years
  of expertise to let their students understand the
  complexities of the technology that they are
  training on.

3

• Global Online Trainings provide online training
  through virtual classes but at no time during our
  training program will you feel that you are not
  connected to us physically.
• Global Online Trainings subject matters experts
  will provide you online tutorials in such an
  engaging and engrossing way that you will never
  feel you are not in a physical classroom.
• Global Online Trainings application sharing,
  remote desktop support, chat to clear doubts,
  virtual white board sharing and question/answer
  sessions are some of our prominent features that
  truly sets us apart from other online training
  provider.

4
Informatica ETL

• Informatica it helps to create a great data.
  Informatica needs for know the marketing skills
  using fantastic fun products and solutions for
  solve different types of data problems.
  Informatica is very powerful ETL tool in market.
  Why informatica compare to other tools, means it
  is simple, powerful, capable to do all ETL with
  efficient results.
• ETL stands for extract transform and load ,as the
  data is read from the heterogeneous sources from
  the source system and loaded in to staging table
  and then finally after the transformations are
  complete it is wrote into a data warehouse.

5

• So the complete process of extracting the data,
  transforming the data and loading the data into
  warehouse is called Extract Transform and Load.
• It not a one off process for dataware housing
  because there are in the operational systems and
  the source systems keeps on changing so this is a
  regular process. Where the data has been
  regularly fetched from the social system and
  loaded into a warehouse after transformations are
  complete.

6
ETL Testing Work Flow Process

• ETL testing process is similar to other testing
  process. The ETL testing process is done in two
  ways either Manual Testing or Data Warehouse
  Testing. The main difference in this testing
  other testing is to identifying the source and
  data model.
• In this we explain the step by step process of
  ETL testing. The first step is to estimation, in
  this number of tables complexity of business
  rules and volume of the data what we are going to
  move from source to staging and the performance
  of the table.
• Then next one is planning, in this it involve
  what is in scope and out scope and what are the
  dependency and what are the risk and migration
  plans.

7

• Test design, it depends on mapping document which
  would be shot by business team or development
  team. An also it involves in sql scripts and test
  scenarios.
• Execution it is the most important step in ETL
  testing, in this execution it involves to monitor
  jobs. And also defect retesting and regression
  testing.
• Finally the step is closure, the closure activity
  as usual so giving the sign off and promoting the
  code to next phase.

8
Features and Capabilities of ETL tools

• The data connectivity with the source and the
  target system, the ETL tools will allow to
  connect put the source and the target data
  systems efficiently and seamlessly.
• Scalability and performance, we should not be
  able to change a job in order to perform it
  better, whenever the data has been increased.
• ETL tool should have pre-built transformation
  connectors which allow doing the transformation
  easily and quickly.
• ETL tool should have a data profiling and data
  cleaning components, which allows standardizing
  and cleaning the data.

9

• It also have a can abilities easily performed
  logging and exception handling.
• It should have robust administration features,
  which allow us to schedule the jobs.
• And it is connect easily to get with web
  services.
• It has capability to perform the operations in
  batch as well as the real time.

10
THANK YOU!
www.globalonlinetrainings.comm