- Open Informatica power center designer
- Add a repository
- Click on “Repository -> Add”
- Enter a repository and username
- Click on ok
- Connect to a repository
- Right click on created repository
- Click on connect
- Click on Add under “Connection Settings” section
- Enter value for “Domain name”, “Gateway Host” and “Gateway port”
- Click on Ok
- Select the security domain
- Enter password
- Click on connect
- Connect to a folder
- Right click on folder which you want to work
- Click on Open
- Creating “Source Analyzer”
- Click on “Source Analyzer” icon
- Click on Sources from toolbar and select “Import from Database” or “Import from file”
- Select “data source”
- Enter username, schema, and password
- Click on connect
- You can see the list of tables under “Select Tables” section
- Select a table
- Click on ok
- Creating “Target Designer”
- Click on “Target Designer” icon
- Click on Targets from toolbar and select “Import from Database”
- Select “data source”
- Enter username, schema, and password
- Click on connect
- You can see the list of tables under “Select Tables” section
- Select a table
- Click on ok
- Creating Mappings
- Click on “Mapping Designer” icon
- Click on Mappings from toolbar and select “Create”
- Enter mapping name and click ok
- Drag and drop the created Source Analyzer and Target Designer
- Click on Transformation from toolbar and select “Create”
- Select type of transformation
- Enter the name for transformation
- Select the columns from source and drag into transformation component
- Double click on transformation
- Creating Workflow
- Click on “Workflow Manager” icon
- Connect to the repository
- Right click on folder and select Open
- Click on “task” from toolbar and select create
- Select the task type as “Session”
- Enter session name
- Click on Ok
- Select the created mapping and click ok
- Double click on Session
- Click on Mapping tab
- Select the source table
- Set source database connections under “connections” section
- Select the target table
- Set target database connections under “connections” section
- Link the Start task and session task
- Running Workflow
- In workflow Designer section, right click on workflow and select “Start workflow”
- Monitoring Workflow
- “Workflow monitor” will be opened automatically when we start a workflow
- The execution status will be displayed
- Double click on the session
- Session information including Source/Target statistics will be displayed
Pages
- Manual Testing Tutorials
- Manual Testing Materials
- Manual Testing Interview Q & A
- ISTQB
- UNIX /Linux
- SQL
- Agile Methodology
- Selenium with Java
- Selenium with Python
- Automation Testing Materials
- API Testing
- Advanced Java
- Cypress Tutorials
- ETL Testing Documents
- ETL Testing videos
- Big Data Hadoop
- SDET Essentials
- Miscellaneous Topics
- Career Guidance
- Mock Interviews
- Resume Templates
- YouTube Videos
- Online Training
- Udemy Courses
ETL job development steps in Informatica
Popular Posts
- How To Explain Project In Interview Freshers and Experienced
- Selenium Frequently Asked Questions & Answers Part-6
- API/Webservices Testing using RestAssured (Part 1)
- How to use HashMap in Selenium WebDriver
- Java Programs for Selenium
- Manual & Automation Testing Free Video Tutorials | YouTube Playlists
- Manual Testing Interview Questions & Answers-PART1
- ETL Test Scenarios and Test Cases
- Python Interview Questions and Answers Part-1
Followers
Labels
a Software Tester or a Developer?
(1)
Adhoc Testing
(1)
Agile
(33)
Agile Team
(1)
Agile Testing
(2)
apache poi
(1)
Appium
(1)
Appium FAQ'S
(1)
Banking Domain
(1)
Core Java scripts
(4)
Cross-browser Web Testing
(1)
How to use Java Collections
(1)
ISTQB
(1)
ISTQB Sample Question Paper
(10)
Java
(5)
Java Interview Questions
(2)
Java Programs for Selenium
(1)
Jira
(1)
Linux
(7)
Manual Testing
(48)
Manual Testing Interview Questions
(2)
Maven Questions & Answers
(1)
Mobile Application
(1)
Mobile application testing
(1)
Mobile Application Types
(1)
Mobile Testing
(2)
NoSQL
(1)
ORACLE
(9)
PL/SQL
(1)
Scrum
(1)
SDLC
(33)
Selenium
(6)
Selenium Common Exceptions
(1)
Selenium FAQ
(5)
Selenium FAQ's
(1)
Selenium Grid
(1)
Selenium Interview Questions
(1)
Set Career Goals
(1)
Shell Scripting
(6)
Skills Required for Software Tester
(1)
Software Testing
(43)
Sprint
(1)
SQL
(11)
STLC
(33)
T-SQL
(1)
Testing E-commerce Websites
(1)
Testing Life Cycle
(33)
Testing process
(8)
TestNG
(7)
TestNG Questions & Answers
(1)
TestNG Assertions
(1)
TestNG Scripts
(4)
VI Editor
(6)
Web Services Testing
(1)
Web Testing
(1)
WebDriver
(6)
Webdriver Questions & Answers
(1)
Webservices API Testing
(1)
Writing Good Agile User Stories
(1)
WwebDriver Scripts
(4)