Question
The following questions are in reference to the Informatica PowerCenter (Version 9.1.0) Getting Started Guide: https://gowthamivuppala.files.wordpress.com/2013/04/pc_910_gettingstartedguide_en.pdf 1. If data is going through ETL as it
The following questions are in reference to the Informatica PowerCenter (Version 9.1.0) Getting Started Guide: https://gowthamivuppala.files.wordpress.com/2013/04/pc_910_gettingstartedguide_en.pdf
1. If data is going through ETL as it is brought into the target/data warehouse, the source data must be coming from a(n) ____ data source.
2. Look at page 34 of the Getting Started Guide. What would be the "fill ratio" of the EMPLOYEE_ID column of the T_EMPLOYEES table? Why?
3. In a Pass-Through Mapping, which of the three main components has both input and output ports?
4. How does one configure periodic refreshes of data using the Integration Service? Be sure to specify the PC component and feature(s) required.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started