Informatica Online Training

4.8

Last Updated:November 16, 2024

Course Duration: 40h

About Course

H2K Infosys is a reliable one training portal that provides job oriented informatica online training with real time examples. We teach informatica concepts according to current job market during sessions.

Course Highlights

Course Curriculum

DATA WAREHOUSE CONCEPTS

Need of Data Warehouse
Characteristics of OLTP and OLAP
Significance of ETL

Architecture of Data Warehouse

Slowly Changing Dimensions (SCD)

Types of Dimensions and Fact Tables

ETL in Bigdata World

Understanding the Role of a Developer

Overview of Different Client Tools

Mapping Designer and Transformations

Tools for Unit Testing

Different Types of Sources

Workflow Tasks

Reusable Features in Informatica

Advance Features in Informatica

Types of Repositories

ETL Testing

Miscellaneous

Informatica Interview Questions and Answers

Course Description

Our Informatica online training course is the most complete, practical, job targeted and easy to learn class out there. It is designed keeping in mind the current and future emerging trends in the world of Data warehousing. The class is taught by pioneers and leaders in the field and will bring to you the concepts blended uniquely with real time experiences.

What is Informatica?

Informatica is a data integration software solution that comes with various features and tools that help maintain and create complex data warehouses. It has various capabilities like ETL, data masking, data mapping etc.

Its main component, the Infomatica PowerCenter helps transform data into various formats.

Concepts like Data transformation, data mapping, workflows, data flow between different sources and targets, normalization, slowly changing dimensions, tasks & scheduling are the core of Informatica.

Our course targets all the areas and then some to make the Informatica learning experience beneficial and rewarding.

In the data centric business world, anything can go out of style and use-but not data and its related processes and skills. So, Informatica experiences going to be extremely beneficial for the career in the data field. The salient features of our course are explained below.

Informatica course highlights

The course will progress in a logical fashion to introduce the basics and then move towards the most advanced topics like Constraint based load, Incremental Aggregation, PMCMD etc.
In depth understanding of Data Warehouse systems, ETL and SQL are provided to start with.
It is a Live teacher led class that encourages participant and teacher interaction
All the concepts are explained with the help of real time examples.
Assignments are designed in a way that the theory learned can be easily applied to practical situations.
Interview Questions are discussed and job-targeted coaching is provided.
Lectures are available for offline review.
Resume and job search assistance is provided.

Frequently Asked Questions

Placement Rate

0 %

Hiring Partners

0 +

Average hike

0 %

Learners

0 K+

Days

Hours

Minutes

Seconds

enroll free online demo class

How it works?

Learning

Gain industry-relevant knowledge through expert-led courses and live training.

Practice

Strengthen your skills with hands-on exercises, assignments, and labs.

Quiz/Test

Evaluate your understanding with quizzes, tests, and certification assessments.

Real-Time Projects

Work on live projects to gain practical, job-ready experience.

Resume Building

Get expert guidance to craft a compelling, professional resume.

Optimize your LinkedIn profile to enhance your professional presence.

GitHub

Showcase your coding and project work with a strong GitHub portfolio.

Job Placement

Access career support, mock interviews, and job placement assistance.

Popular Courses

H2K Infosys Certification

Have Any Question?

Here are more reasons

Why Choose H2K Infosys

Elevate Your Career Progress with H2K Infosys

Get ready for your dream role with our practice interviews, and secure an advantage through hackathons and job expos. Our mission is to help you distinguish yourself.

72%

Alumni Career Transitions

2800+

Hiring Companies

Enjoy Personalized Assistance

Our team delivers personalized guidance and services crafted to address your distinct needs, promising a one-of-a-kind, gratifying journey for every individual. Initiate your path to triumph today.

2,10,000+

Mentorship Sessions Completed

4.7/5

Average Mentor Rating

Our Alumni Share Their Experiences

Here are more reasons

Testimonials

CJ Bhinder

01:42 27 Jul 24

I am taking a Selenium automation course with trainer Srinivas. It is great going 👍 Srinivas is a heck of a teacher. I will highly recommend Infosys and Srinivas to anyone looking for software training. Also, I'd like to applaude all the help from Chris Arun from the support team. Well done, guys, at H2K Infosys!!

Navdeep Kaur

01:01 27 Jul 24

Ms. Kathy 9:00am Batch (Automation Testing)
I m currently taking my automation Testing class with Ms. Kathy. She is outstanding instructor. She explained complex concepts with such clarity the most challenging topics became easy to understand.

Maliha Mallik

13:46 26 Jul 24

I have taken Tosca and Mobile App Testing classes by Ms. Kathy, she is an amazing instructor, very knowledgeable and boosts your confidence to another level. I would look forward to attend more of her classes and would definitely recommend anyone. She is the best. Thank you so much Ms. Kathy.

sanjay pawar

03:01 26 Jul 24

I am currently attending Selenium Automation from Mr. Shrinivas. he has deep knowledge and simple clearity about the code. I do not have any background in java but I m able to get the topic easily.

Saraswathi Venugopalaraju

20:34 19 Jul 24

I'm currently learning Selenium Automation with Java course. Srinivas is the best experienced instructor. I really appreciate Srinivas teaching style, it's helped me understand the complex topics well. He explains with lot of patience and with real time examples in easy and understandable way. He covered every topic in great detail. Thank you.

Mesbaha Ahamed

23:54 12 Jul 24

I have been taking mobile testing app with Kathy and she has been an amazing instructor and very knowledgeable about subject. I would recommend anyone to take class with Ms Kathy. I wish all the best to her.

Arukula Pratikshya Sarab

14:51 19 Jun 24

Kiran good supporter for Installation.
Priya also good instructor

Christina J

14:49 19 Jun 24

Priya is very a good instructor. Her teaching style makes it easy to understand , learn and retain. Thank you for taking the time to explain core concepts in QA .
Thank you Kiran for patiently helping with tech support.

Nikhil Joshi

14:41 19 Jun 24

This is Hitesha Joshi.
Thank you Kiran for your Help.

Sandros Bekele

14:33 19 Jun 24

Kiran was very helpful and thank you.

Archana Whawal

19:59 18 Jun 24

I recently attended an automation testing training provided by Shantosh Kumar. He is knowledgeable and experienced in teaching the course. He engaged everyone in class with his ability to explain concepts like JAVA,OOPS and all Selenium concepts in a clear and concise manner. He is very responsive and patient, and answered all our questions thoroughly, making sure that we understood the material before moving on to the next topic. He is very supportive and encouraging throughout the training, which helped me feel more confident in my abilities. I would highly recommend him to anyone looking for an effective and engaging automation testing training.

Mayura Nirmal

18:55 17 Jun 24

I am currently attending Selenium classes from Mr. Shantosh. The instructor is excellent and clearly very knowledgeable about the topics. When I started, I had zero Java knowledge(background) and wasn’t confident. But I am amazed with his teaching skills, as he made Java and Selenium classes so simple to understand, making the subject more interesting and easier to follow. There is no hesitation in asking any question at any time as he makes everyone engaged during the class. The training is very well structured and organized. The one thing I like most is he always gives the real time scenarios and focuses on the interview question topics. I would like to thank him for his efforts and guidance provided.
I highly recommend him if you are thinking of this course training in future.

Veena Jagtap

18:53 17 May 24

I am currently learning automation testing from Ms. Kathy. She is an amazing trainer. She always makes sure that she starts the class with a positive note. No one will be left un attended in her class as she addresses everyone in the class by their names to make sure that everyone is responding to the questions asked and are clear with all the topics taught. Her way of explaining things make it so easier to understand. She asks everyone to elaborate their answers individually, by doing so she develops the presentation skills of the students. Thank you so much Ms. Kathy for being a wonderful trainer.

Dhrupal Patel

22:59 14 May 24

Ms. Kathy is a great trainer with thorough knowledge. She is very lively during the class, which makes learning interesting. Her teaching methods are very clear and practical and she explains in detail with example. I highly recommend her sessions. She answers your questions if you are confused. Her personal attention and seamless effort to ensure each and every student learn the concept is great.

Sanjisha Sood

17:39 01 Apr 24

UFT Sessions by Ms Kathy:
Kathy is a great trainer with thorough knowledge. She is very lively during the class, which makes learning interesting. The best part of her teaching methodology is, she would make sure that everyone is interacting in the class and is not just a passive listener. Her classes not only incorporate the subject material but help building confidence to speak and share thoughts on the topic. She patiently clears all doubts. Her positive reinforcement motivates a lot. Thank you Kathy!

Want to receive push notifications for all major on-site activities?

img:is([sizes="auto" i],[sizes^="auto," i]){contain-intrinsic-size:3000px 1500px;}img.wp-smiley,img.emoji{display:inline !important;border:none !important;box-shadow:none !important;height:1em !important;width:1em !important;margin:0 .07em !important;vertical-align:-.1em !important;background:none !important;padding:0 !important;}:root{--wp--preset--aspect-ratio--square:1;--wp--preset--aspect-ratio--4-3:4/3;--wp--preset--aspect-ratio--3-4:3/4;--wp--preset--aspect-ratio--3-2:3/2;--wp--preset--aspect-ratio--2-3:2/3;--wp--preset--aspect-ratio--16-9:16/9;--wp--preset--aspect-ratio--9-16:9/16;--wp--preset--color--black:#000;--wp--preset--color--cyan-bluish-gray:#abb8c3;--wp--preset--color--white:#fff;--wp--preset--color--pale-pink:#f78da7;--wp--preset--color--vivid-red:#cf2e2e;--wp--preset--color--luminous-vivid-orange:#ff6900;--wp--preset--color--luminous-vivid-amber:#fcb900;--wp--preset--color--light-green-cyan:#7bdcb5;--wp--preset--color--vivid-green-cyan:#00d084;--wp--preset--color--pale-cyan-blue:#8ed1fc;--wp--preset--color--vivid-cyan-blue:#0693e3;--wp--preset--color--vivid-purple:#9b51e0;--wp--preset--gradient--vivid-cyan-blue-to-vivid-purple:linear-gradient(135deg,rgba(6,147,227,1) 0%,#9b51e0 100%);--wp--preset--gradient--light-green-cyan-to-vivid-green-cyan:linear-gradient(135deg,#7adcb4 0%,#00d082 100%);--wp--preset--gradient--luminous-vivid-amber-to-luminous-vivid-orange:linear-gradient(135deg,rgba(252,185,0,1) 0%,rgba(255,105,0,1) 100%);--wp--preset--gradient--luminous-vivid-orange-to-vivid-red:linear-gradient(135deg,rgba(255,105,0,1) 0%,#cf2e2e 100%);--wp--preset--gradient--very-light-gray-to-cyan-bluish-gray:linear-gradient(135deg,#eee 0%,#a9b8c3 100%);--wp--preset--gradient--cool-to-warm-spectrum:linear-gradient(135deg,#4aeadc 0%,#9778d1 20%,#cf2aba 40%,#ee2c82 60%,#fb6962 80%,#fef84c 100%);--wp--preset--gradient--blush-light-purple:linear-gradient(135deg,#ffceec 0%,#9896f0 100%);--wp--preset--gradient--blush-bordeaux:linear-gradient(135deg,#fecda5 0%,#fe2d2d 50%,#6b003e 100%);--wp--preset--gradient--luminous-dusk:linear-gradient(135deg,#ffcb70 0%,#c751c0 50%,#4158d0 100%);--wp--preset--gradient--pale-ocean:linear-gradient(135deg,#fff5cb 0%,#b6e3d4 50%,#33a7b5 100%);--wp--preset--gradient--electric-grass:linear-gradient(135deg,#caf880 0%,#71ce7e 100%);--wp--preset--gradient--midnight:linear-gradient(135deg,#020381 0%,#2874fc 100%);--wp--preset--font-size--small:13px;--wp--preset--font-size--medium:20px;--wp--preset--font-size--large:36px;--wp--preset--font-size--x-large:42px;--wp--preset--spacing--20:.44rem;--wp--preset--spacing--30:.67rem;--wp--preset--spacing--40:1rem;--wp--preset--spacing--50:1.5rem;--wp--preset--spacing--60:2.25rem;--wp--preset--spacing--70:3.38rem;--wp--preset--spacing--80:5.06rem;--wp--preset--shadow--natural:6px 6px 9px rgba(0,0,0,.2);--wp--preset--shadow--deep:12px 12px 50px rgba(0,0,0,.4);--wp--preset--shadow--sharp:6px 6px 0px rgba(0,0,0,.2);--wp--preset--shadow--outlined:6px 6px 0px -3px rgba(255,255,255,1),6px 6px rgba(0,0,0,1);--wp--preset--shadow--crisp:6px 6px 0px rgba(0,0,0,1);}:root{--wp--style--global--content-size:800px;--wp--style--global--wide-size:1200px;}:where(body){margin:0;}.wp-site-blocks > .alignleft{float:left;margin-right:2em;}.wp-site-blocks > .alignright{float:right;margin-left:2em;}.wp-site-blocks > .aligncenter{justify-content:center;margin-left:auto;margin-right:auto;}:where(.wp-site-blocks) > *{margin-block-start:24px;margin-block-end:0;}:where(.wp-site-blocks) > :first-child{margin-block-start:0;}:where(.wp-site-blocks) > :last-child{margin-block-end:0;}:root{--wp--style--block-gap:24px;}:root :where(.is-layout-flow) > :first-child{margin-block-start:0;}:root :where(.is-layout-flow) > :last-child{margin-block-end:0;}:root :where(.is-layout-flow) > *{margin-block-start:24px;margin-block-end:0;}:root :where(.is-layout-constrained) > :first-child{margin-block-start:0;}:root :where(.is-layout-constrained) > :last-child{margin-block-end:0;}:root :where(.is-layout-constrained) > *{margin-block-start:24px;margin-block-end:0;}:root :where(.is-layout-flex){gap:24px;}:root :where(.is-layout-grid){gap:24px;}.is-layout-flow > .alignleft{float:left;margin-inline-start:0;margin-inline-end:2em;}.is-layout-flow > .alignright{float:right;margin-inline-start:2em;margin-inline-end:0;}.is-layout-flow > .aligncenter{margin-left:auto !important;margin-right:auto !important;}.is-layout-constrained > .alignleft{float:left;margin-inline-start:0;margin-inline-end:2em;}.is-layout-constrained > .alignright{float:right;margin-inline-start:2em;margin-inline-end:0;}.is-layout-constrained > .aligncenter{margin-left:auto !important;margin-right:auto !important;}.is-layout-constrained > :where(:not(.alignleft):not(.alignright):not(.alignfull)){max-width:var(--wp--style--global--content-size);margin-left:auto !important;margin-right:auto !important;}.is-layout-constrained > .alignwide{max-width:var(--wp--style--global--wide-size);}body .is-layout-flex{display:flex;}.is-layout-flex{flex-wrap:wrap;align-items:center;}.is-layout-flex > :is(*,div){margin:0;}body .is-layout-grid{display:grid;}.is-layout-grid > :is(*,div){margin:0;}body{padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}a:where(:not(.wp-element-button)){text-decoration:underline;}:root :where(.wp-element-button,.wp-block-button__link){background-color:#32373c;border-width:0;color:#fff;font-family:inherit;font-size:inherit;line-height:inherit;padding:calc(.667em + 2px) calc(1.333em + 2px);text-decoration:none;}.has-black-color{color:var(--wp--preset--color--black) !important;}.has-cyan-bluish-gray-color{color:var(--wp--preset--color--cyan-bluish-gray) !important;}.has-white-color{color:var(--wp--preset--color--white) !important;}.has-pale-pink-color{color:var(--wp--preset--color--pale-pink) !important;}.has-vivid-red-color{color:var(--wp--preset--color--vivid-red) !important;}.has-luminous-vivid-orange-color{color:var(--wp--preset--color--luminous-vivid-orange) !important;}.has-luminous-vivid-amber-color{color:var(--wp--preset--color--luminous-vivid-amber) !important;}.has-light-green-cyan-color{color:var(--wp--preset--color--light-green-cyan) !important;}.has-vivid-green-cyan-color{color:var(--wp--preset--color--vivid-green-cyan) !important;}.has-pale-cyan-blue-color{color:var(--wp--preset--color--pale-cyan-blue) !important;}.has-vivid-cyan-blue-color{color:var(--wp--preset--color--vivid-cyan-blue) !important;}.has-vivid-purple-color{color:var(--wp--preset--color--vivid-purple) !important;}.has-black-background-color{background-color:var(--wp--preset--color--black) !important;}.has-cyan-bluish-gray-background-color{background-color:var(--wp--preset--color--cyan-bluish-gray) !important;}.has-white-background-color{background-color:var(--wp--preset--color--white) !important;}.has-pale-pink-background-color{background-color:var(--wp--preset--color--pale-pink) !important;}.has-vivid-red-background-color{background-color:var(--wp--preset--color--vivid-red) !important;}.has-luminous-vivid-orange-background-color{background-color:var(--wp--preset--color--luminous-vivid-orange) !important;}.has-luminous-vivid-amber-background-color{background-color:var(--wp--preset--color--luminous-vivid-amber) !important;}.has-light-green-cyan-background-color{background-color:var(--wp--preset--color--light-green-cyan) !important;}.has-vivid-green-cyan-background-color{background-color:var(--wp--preset--color--vivid-green-cyan) !important;}.has-pale-cyan-blue-background-color{background-color:var(--wp--preset--color--pale-cyan-blue) !important;}.has-vivid-cyan-blue-background-color{background-color:var(--wp--preset--color--vivid-cyan-blue) !important;}.has-vivid-purple-background-color{background-color:var(--wp--preset--color--vivid-purple) !important;}.has-black-border-color{border-color:var(--wp--preset--color--black) !important;}.has-cyan-bluish-gray-border-color{border-color:var(--wp--preset--color--cyan-bluish-gray) !important;}.has-white-border-color{border-color:var(--wp--preset--color--white) !important;}.has-pale-pink-border-color{border-color:var(--wp--preset--color--pale-pink) !important;}.has-vivid-red-border-color{border-color:var(--wp--preset--color--vivid-red) !important;}.has-luminous-vivid-orange-border-color{border-color:var(--wp--preset--color--luminous-vivid-orange) !important;}.has-luminous-vivid-amber-border-color{border-color:var(--wp--preset--color--luminous-vivid-amber) !important;}.has-light-green-cyan-border-color{border-color:var(--wp--preset--color--light-green-cyan) !important;}.has-vivid-green-cyan-border-color{border-color:var(--wp--preset--color--vivid-green-cyan) !important;}.has-pale-cyan-blue-border-color{border-color:var(--wp--preset--color--pale-cyan-blue) !important;}.has-vivid-cyan-blue-border-color{border-color:var(--wp--preset--color--vivid-cyan-blue) !important;}.has-vivid-purple-border-color{border-color:var(--wp--preset--color--vivid-purple) !important;}.has-vivid-cyan-blue-to-vivid-purple-gradient-background{background:var(--wp--preset--gradient--vivid-cyan-blue-to-vivid-purple) !important;}.has-light-green-cyan-to-vivid-green-cyan-gradient-background{background:var(--wp--preset--gradient--light-green-cyan-to-vivid-green-cyan) !important;}.has-luminous-vivid-amber-to-luminous-vivid-orange-gradient-background{background:var(--wp--preset--gradient--luminous-vivid-amber-to-luminous-vivid-orange) !important;}.has-luminous-vivid-orange-to-vivid-red-gradient-background{background:var(--wp--preset--gradient--luminous-vivid-orange-to-vivid-red) !important;}.has-very-light-gray-to-cyan-bluish-gray-gradient-background{background:var(--wp--preset--gradient--very-light-gray-to-cyan-bluish-gray) !important;}.has-cool-to-warm-spectrum-gradient-background{background:var(--wp--preset--gradient--cool-to-warm-spectrum) !important;}.has-blush-light-purple-gradient-background{background:var(--wp--preset--gradient--blush-light-purple) !important;}.has-blush-bordeaux-gradient-background{background:var(--wp--preset--gradient--blush-bordeaux) !important;}.has-luminous-dusk-gradient-background{background:var(--wp--preset--gradient--luminous-dusk) !important;}.has-pale-ocean-gradient-background{background:var(--wp--preset--gradient--pale-ocean) !important;}.has-electric-grass-gradient-background{background:var(--wp--preset--gradient--electric-grass) !important;}.has-midnight-gradient-background{background:var(--wp--preset--gradient--midnight) !important;}.has-small-font-size{font-size:var(--wp--preset--font-size--small) !important;}.has-medium-font-size{font-size:var(--wp--preset--font-size--medium) !important;}.has-large-font-size{font-size:var(--wp--preset--font-size--large) !important;}.has-x-large-font-size{font-size:var(--wp--preset--font-size--x-large) !important;}:root :where(.wp-block-pullquote){font-size:1.5em;line-height:1.6;}.mce-notification.mce-notification-error{display:none !important;}:root{--tutor-color-primary:#3e64de;--tutor-color-primary-rgb:62,100,222;--tutor-color-primary-hover:#395bca;--tutor-color-primary-hover-rgb:57,91,202;--tutor-body-color:#212327;--tutor-body-color-rgb:33,35,39;--tutor-border-color:#cdcfd5;--tutor-border-color-rgb:205,207,213;--tutor-color-gray:#e3e5eb;--tutor-color-gray-rgb:227,229,235;}.a-stats{--akismet-color-mid-green:#357b49;--akismet-color-white:#fff;--akismet-color-light-grey:#f6f7f7;max-width:350px;width:auto;}.a-stats *{all:unset;box-sizing:border-box;}.a-stats strong{font-weight:600;}.a-stats a.a-stats__link,.a-stats a.a-stats__link:visited,.a-stats a.a-stats__link:active{background:var(--akismet-color-mid-green);border:none;box-shadow:none;border-radius:8px;color:var(--akismet-color-white);cursor:pointer;display:block;font-family:-apple-system,BlinkMacSystemFont,"Segoe UI","Roboto","Oxygen-Sans","Ubuntu","Cantarell","Helvetica Neue",sans-serif;font-weight:500;padding:12px;text-align:center;text-decoration:none;transition:all .2s ease;}.widget .a-stats a.a-stats__link:focus{background:var(--akismet-color-mid-green);color:var(--akismet-color-white);text-decoration:none;}.a-stats a.a-stats__link:hover{filter:brightness(110%);box-shadow:0 4px 12px rgba(0,0,0,.06),0 0 2px rgba(0,0,0,.16);}.a-stats .count{color:var(--akismet-color-white);display:block;font-size:1.5em;line-height:1.4;padding:0 13px;white-space:nowrap;}.e-con.e-parent:nth-of-type(n+4):not(.e-lazyloaded):not(.e-no-lazyload),.e-con.e-parent:nth-of-type(n+4):not(.e-lazyloaded):not(.e-no-lazyload) *{background-image:none !important;}@media screen and (max-height: 1024px){.e-con.e-parent:nth-of-type(n+3):not(.e-lazyloaded):not(.e-no-lazyload),.e-con.e-parent:nth-of-type(n+3):not(.e-lazyloaded):not(.e-no-lazyload) *{background-image:none !important;}.e-con.e-parent:nth-of-type(n+3):not(.e-lazyloaded):not(.e-no-lazyload).nitro-lazy,.e-con.e-parent:nth-of-type(n+3):not(.e-lazyloaded):not(.e-no-lazyload) *.nitro-lazy{background-image:none !important;}}@media screen and (max-height: 640px){.e-con.e-parent:nth-of-type(n+2):not(.e-lazyloaded):not(.e-no-lazyload),.e-con.e-parent:nth-of-type(n+2):not(.e-lazyloaded):not(.e-no-lazyload) *{background-image:none !important;}.e-con.e-parent:nth-of-type(n+2):not(.e-lazyloaded):not(.e-no-lazyload).nitro-lazy,.e-con.e-parent:nth-of-type(n+2):not(.e-lazyloaded):not(.e-no-lazyload) *.nitro-lazy{background-image:none !important;}}.e-con.e-parent:nth-of-type(n+4):not(.e-lazyloaded):not(.e-no-lazyload).nitro-lazy,.e-con.e-parent:nth-of-type(n+4):not(.e-lazyloaded):not(.e-no-lazyload) *.nitro-lazy{background-image:none !important;}.momo{color:#111f62 !important;font-size:17px !important;font-weight:600 !important;}.elementor-icon i:hover{}.elementor-element-f924a90{display:block !important;}.elementor-570 .elementor-element.elementor-element-3e44c1e5 .tutor-course-details-widget-col-2 ul{display:block !important;}.page-header{display:none;}.envato-block__preview{overflow:visible;}.elementor-headline-animation-type-drop-in .elementor-headline-dynamic-wrapper{text-align:center;}.envato-kit-141-top-0 h1,.envato-kit-141-top-0 h2,.envato-kit-141-top-0 h3,.envato-kit-141-top-0 h4,.envato-kit-141-top-0 h5,.envato-kit-141-top-0 h6,.envato-kit-141-top-0 p{margin-top:0;}.envato-kit-141-newsletter-inline .elementor-field-textual.elementor-size-md{padding-left:1.5rem;padding-right:1.5rem;}.envato-kit-141-bottom-0 p{margin-bottom:0;}.envato-kit-141-bottom-8 .elementor-price-list .elementor-price-list-item .elementor-price-list-header{margin-bottom:.5rem;}.envato-kit-141.elementor-widget-testimonial-carousel.elementor-pagination-type-bullets .swiper-container{padding-bottom:52px;}.envato-kit-141-display-inline{display:inline-block;}.envato-kit-141 .elementor-slick-slider ul.slick-dots{bottom:-40px;}.envato-block__preview{overflow:visible;}.envato-kit-139-accordion .elementor-widget-container{border-radius:10px !important;}.envato-kit-139-map iframe,.envato-kit-139-slider .slick-slide,.envato-kit-139-flipbox .elementor-flip-box div{border-radius:10px !important;}.envato-block__preview{overflow:visible;}.envato-kit-69-slide-btn .elementor-button,.envato-kit-69-cta-btn .elementor-button,.envato-kit-69-flip-btn .elementor-button{border-left:0px !important;border-bottom:0px !important;border-right:0px !important;padding:15px 0 0 !important;}.envato-kit-69-slide-btn .elementor-slide-button:hover,.envato-kit-69-cta-btn .elementor-button:hover,.envato-kit-69-flip-btn .elementor-button:hover{margin-bottom:20px;}.envato-kit-69-menu .elementor-nav-menu--main a:hover{margin-top:-7px;padding-top:4px;border-bottom:1px solid #fff;}.envato-kit-69-menu .elementor-nav-menu--dropdown{width:100% !important;}.envato-block__preview{overflow:visible;}.envato-kit-30-phone-overlay{position:absolute !important;display:block !important;top:0%;left:0%;right:0%;margin:auto;z-index:1;}.envato-kit-30-div-rotate{transform:rotate(90deg);}.envato-kit-138-bracket .elementor-widget-container > *:before{content:"[";color:#ffab00;display:inline-block;margin-right:4px;line-height:1em;position:relative;top:-1px;}.envato-kit-138-bracket .elementor-widget-container > *:after{content:"]";color:#ffab00;display:inline-block;margin-left:4px;line-height:1em;position:relative;top:-1px;}.envato-block__preview{overflow:visible !important;}.envato-kit-66-menu .e--pointer-framed .elementor-item:before{border-radius:1px;}.envato-kit-66-subscription-form .elementor-form-fields-wrapper{position:relative;}.envato-kit-66-subscription-form .elementor-form-fields-wrapper .elementor-field-type-submit{position:static;}.envato-kit-66-subscription-form .elementor-form-fields-wrapper .elementor-field-type-submit button{position:absolute;top:50%;right:6px;transform:translate(0,-50%);-moz-transform:translate(0,-50%);-webmit-transform:translate(0,-50%);}.envato-kit-66-testi-slider .elementor-testimonial__footer{margin-top:-60px !important;z-index:99;position:relative;}.envato-kit-66-featured-slider .elementor-slides .slick-prev{width:50px;height:50px;background-color:#fff !important;transform:rotate(45deg);-moz-transform:rotate(45deg);-webkit-transform:rotate(45deg);left:-25px !important;-webkit-box-shadow:0px 1px 2px 1px rgba(0,0,0,.32);-moz-box-shadow:0px 1px 2px 1px rgba(0,0,0,.32);box-shadow:0px 1px 2px 1px rgba(0,0,0,.32);}.envato-kit-66-featured-slider .elementor-slides .slick-prev:before{display:block;margin-top:0px;margin-left:0px;transform:rotate(-45deg);-moz-transform:rotate(-45deg);-webkit-transform:rotate(-45deg);}.envato-kit-66-featured-slider .elementor-slides .slick-next{width:50px;height:50px;background-color:#fff !important;transform:rotate(45deg);-moz-transform:rotate(45deg);-webkit-transform:rotate(45deg);right:-25px !important;-webkit-box-shadow:0px 1px 2px 1px rgba(0,0,0,.32);-moz-box-shadow:0px 1px 2px 1px rgba(0,0,0,.32);box-shadow:0px 1px 2px 1px rgba(0,0,0,.32);}.envato-kit-66-featured-slider .elementor-slides .slick-next:before{display:block;margin-top:-5px;margin-right:-5px;transform:rotate(-45deg);-moz-transform:rotate(-45deg);-webkit-transform:rotate(-45deg);}.envato-kit-66-orangetext{color:#f4511e;}.envato-kit-66-countdown .elementor-countdown-label{display:inline-block !important;border:2px solid rgba(255,255,255,.2);padding:9px 20px;}.elementor-1375 .elementor-element.elementor-element-27beb510 .elementskit-section-title-wraper .elementskit-section-title{margin:0px 0px 10px 0px !important;}.sli .elementor-swiper-button svg{border-radius:30px !important;background:#5754f7;}.elementor-element-b9a9b3d{padding:0px;margin:0px;}.elementor-809{overflow:hidden !important;}.texat{text-decoration:none !important;}.tutor-wrap{padding:50px 0px !important;}.envato-block__preview{overflow:visible;}.envato-kit-140-material-hit .menu-item a,.envato-kit-140-material-button .elementor-button{background-position:center;transition:background .8s;}.envato-kit-140-material-hit .menu-item a:hover,.envato-kit-140-material-button .elementor-button:hover{background:radial-gradient(circle,transparent 1%,#fff 1%) center/15000%;}.envato-kit-140-material-hit .menu-item a:active,.envato-kit-140-material-button .elementor-button:active{background-color:#fff;background-size:100%;transition:background 0s;}.envato-kit-140-big-shadow-form .elementor-field-textual{box-shadow:0 20px 30px rgba(0,0,0,.05);}.envato-kit-140-faq .elementor-accordion .elementor-accordion-item{border-width:0 0 1px !important;}.envato-kit-140-scrollable{height:100%;overflow:auto;overflow-x:hidden;}.envato-kit-140-imagebox-nospace:hover{transform:scale(1.1);transition:all .3s;}.envato-kit-140-imagebox-nospace figure{line-height:0;}.envato-kit-140-slide .elementor-slide-content{background:#fff;margin-left:-60px;padding:1em;}.envato-kit-140-carousel .slick-active:not(.slick-current) img{padding:20px !important;transition:all .9s;}.envato-kit-102-phone-overlay{position:absolute !important;display:block !important;top:0%;left:0%;right:0%;margin:auto;z-index:1;}#uc_content_accordion_elementor_aa9bc6e *{box-sizing:border-box;}#uc_content_accordion_elementor_aa9bc6e .uc_ac_box{overflow:hidden;}#uc_content_accordion_elementor_aa9bc6e .ue_heading_title{margin:0;flex-grow:1;display:flex;flex-direction:row;}#uc_content_accordion_elementor_aa9bc6e .uc_container .uc-heading{display:flex;align-items:center;overflow:hidden;cursor:pointer;}#uc_content_accordion_elementor_aa9bc6e .uc_container .uc_content{display:none;}#uc_content_accordion_elementor_aa9bc6e .uc_container .uc-heading span.ue_accordion_icon{display:flex;align-items:center;justify-content:center;flex-grow:0;flex-shrink:0;}#uc_content_accordion_elementor_aa9bc6e .uc_ac_box.uc-item-active span.uc_dactive{display:none;}#uc_content_accordion_elementor_aa9bc6e .uc_ac_box:not(.uc-item-active) span.uc_active{display:none;}#uc_content_accordion_elementor_aa9bc6e span.ue_accordion_icon svg{height:1em;width:1em;}#uc_content_accordion_elementor_aa9bc6e .uc_container .uc_btn{text-align:center;display:inline-block;text-decoration:none;transition:ease-in-out all .25s;}#uc_content_accordion_elementor_aa9bc6e .ue-item-image img{width:100%;display:block;object-fit:cover;}#uc_vertical_curve_timeline_elementor_787a739.ue-container{width:100%;display:flex;align-items:center;}#uc_vertical_curve_timeline_elementor_787a739 .ue-timeline{width:100%;margin:0 auto;padding:0 20px;}#uc_vertical_curve_timeline_elementor_787a739 .ue-card{position:relative;display:flex;}#uc_vertical_curve_timeline_elementor_787a739 .ue-slno{border-radius:50%;position:absolute;top:50%;left:0;transform:translate(-50%,-50%);display:grid;place-content:center;}#uc_vertical_curve_timeline_elementor_787a739 .ue-card:nth-child(odd){padding:30px 0 30px 30px;}#uc_vertical_curve_timeline_elementor_787a739 .ue-card:nth-child(even){padding:30px 30px 30px 0;}#uc_vertical_curve_timeline_elementor_787a739 .ue-card::before{content:"";position:absolute;width:50%;}#uc_vertical_curve_timeline_elementor_787a739 .ue-card:nth-child(odd)::before{left:0px;top:-4.5px;bottom:-4.5px;border-width:5px 0 5px 5px;border-radius:20px 0 0 20px;}@media only screen and (max-width: 400px){#uc_vertical_curve_timeline_elementor_787a739 .ue-card:nth-child(odd)::before{top:-5px;bottom:-5px;}}#uc_vertical_curve_timeline_elementor_787a739 .ue-card:nth-child(even)::before{right:0;top:0;bottom:0;border-width:5px 5px 5px 0;border-radius:0 20px 20px 0;}#uc_vertical_curve_timeline_elementor_787a739 .ue-card:first-child::before{border-top:0;border-top-left-radius:0;}#uc_vertical_curve_timeline_elementor_787a739 .ue-card:last-child:nth-child(odd)::before{border-bottom:0;border-bottom-left-radius:0;}#uc_vertical_curve_timeline_elementor_787a739 .ue-card:last-child:nth-child(even)::before{border-bottom:0;border-bottom-right-radius:0;}#uc_vertical_curve_timeline_elementor_787a739 .ue-info{display:flex;flex-direction:column;border-radius:10px;padding:10px;width:100%;}#uc_vertical_curve_timeline_elementor_787a739 .ue-title{position:relative;}#uc_vertical_curve_timeline_elementor_787a739 .ue-card:nth-child(even){text-align:right;}#uc_vertical_curve_timeline_elementor_787a739 .ue-card:nth-child(even) .ue-info{padding-right:20px;margin-left:auto;}#uc_vertical_curve_timeline_elementor_787a739 .ue-card:nth-child(odd) .ue-info{padding-left:20px;}#uc_vertical_curve_timeline_elementor_787a739 .ue-card:nth-child(odd) > .ue-info > .ue-title::before{left:-45px;}#uc_vertical_curve_timeline_elementor_787a739 .ue-card:nth-child(even) > .ue-slno{right:0%;left:auto;transform:translate(50%,-50%);margin-right:2px;}#uc_vertical_curve_timeline_elementor_787a739 .ue-card:nth-child(odd) > .ue-slno{margin-left:2px;}#uc_vertical_curve_timeline_elementor_787a739 .ue-card:nth-child(1)::before{height:50%;top:auto;}#uc_vertical_curve_timeline_elementor_787a739 .ue-card:last-child::before{height:50%;}#uc_vertical_curve_timeline_elementor_787a739 .ue-button-link{width:fit-content;z-index:100;}#uc_vertical_curve_timeline_elementor_787a739 .ue-card:nth-child(even) .ue-button-link{margin-left:auto;}.unlimited-elements-background-overlay{position:absolute;top:0px;left:0px;width:100%;height:100%;z-index:0;}.unlimited-elements-background-overlay.uc-bg-front{z-index:999;}

Informatica Online Training

About Course

Course Highlights

Course Curriculum

DATA WAREHOUSE CONCEPTS

Need of Data Warehouse

Characteristics of OLTP and OLAP

Significance of ETL

Architecture of Data Warehouse

Definition of Data Warehouse

Slowly Changing Dimensions (SCD)

SCD Type 1

SCD Type 2

SCD Type 3

Types of Dimensions and Fact Tables

Time Dimension

Types of Facts — Additive, Semi Additive, Non Additive

Fact less Fact Table

ETL in Bigdata World

Introduction to Big Data

Where ETL fits in Big Data World

Introduction to Hadoop

Understanding the Role of a Developer

Understanding the project flow from requirement Gathering to Production

Documentation maintained at each level in the flow

Data Mapping Document

Overview of Different Client Tools

PowerCenter Designer

Source Analyzer

Target Designer

Transformation Designer

Mapplet Designer

Mapping Designer

WorkFlow Manager

Task Developer

Worklet Developer

Workflow Developer

Workflow Monitor

Mapping Designer and Transformations

Create a Simple Mapping

Overview of Transformations

Types of Transformations — Active and Passive

Expression Transformation

Source Qualifier Transformation

Filter Transformation

Router Transformation

Aggregator Transformation

Sorter Transformation

Reusable Transformation

Normalizer Transformation

Union Transformation

Stored Procedure Transformation

Sequence Generator Transformation

Joiner Transformation

Update Strategy Transformation

Lookup Transformation

Static, Dynamic and persistent Lookup Cache

SCD Type 1 mapping Implementation

Connected Vs Un-Connected Transformations

Multiple Pipelines in a Single Mapping

Tools for Unit Testing

Debugger

Verbose Data

Test Load

Different Types of Sources

Flat Files

Delimited Files

Fixed Width Files

Handling Multiple Files as Source (indirect File method)

Data Base Tables

XML Files

Workflow Tasks

Command Task

Email Task

Task Link Properties

Event Raise Task

Event Wait Task

Sequential and Parallel Loading

Scheduler

Reusable Features in Informatica