PR000005 practice question 9 of 25
You have just standardized values in a field and you would like to review how the modified dataappears alongside the original dat a. Which profiling method would best be suited for this?
Full set: 140 questionsMid-stream profiling is the correct method as it is specifically designed to analyze the state of data at any point within a mapping. By adding a Profile transformation immediately after the standardization step, a user can run a profile on the transformed data. The results of this mid-stream profile can then be directly compared with a profile run on the original source data, allowing for a clear side-by-side review of the data before and after the standardization was applied. This directly addresses the need to verify the outcome of a transformation in-flight.
A. Column Profiling is performed on a source or target data object, not on data as it is being transformed within a mapping.
C. Join Analysis Profile is used to analyze the relationship and overlap between columns in different data sources to identify potential join candidates.
D. Comparative Profiling is used to compare the results of two separate profile runs, typically on different data objects or the same object over time.
1. Informatica 10.5 - Data Quality Profiling Guide, Chapter 10: Midstream Profiling, Page 111.
Quote: "You can run a profile on a data source midstream in a mapping. A midstream profile shows the condition of the data after it has passed through one or more transformations. You can use a midstream profile to verify the results of a transformation or to help you debug a mapping." This directly supports the use of mid-stream profiling to review modified data.
2. Informatica 10.5 - Data Quality Profiling Guide, Chapter 2: Column Profiling, Page 18.
Reference: This chapter describes column profiling as an analysis of data objects (sources/targets) stored in the repository, confirming it does not apply to in-flight data within a mapping.
3. Informatica 10.5 - Data Quality Profiling Guide, Chapter 8: Comparative Profiling, Page 99.
Reference: This section explains that comparative profiling compares two profile results to find differences, which is distinct from viewing data as it flows through a single mapping execution.
Keep practicing
Take the free PR000005 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other PR000005 practice questions
- Question 1When you select Suggestion List mode what statement is true?
- Question 2How much data can DQA handle?
- Question 3What is the primary purpose of grouping data?
- Question 4Which definition describes Column Profiling?
- Question 5Which parameter function is supported in IDQ 9.1?
- Question 6Which of the following is not true when it comes to creating and updating Reference Table…
