PR000005 practice question 11 of 25
A customer has provided a number of delimited flat files that require profiling, but not filedefinition. What should you do first?
Full set: 140 questionsThe most efficient and standard initial step when creating a data object from a flat file for profiling in the Informatica Developer tool is to use the import wizard's built-in capabilities. The wizard can sample the file's content to automatically infer column names, data types, precision, and scale. This provides a baseline metadata definition upon which a profile can be run immediately to discover more detailed characteristics of the data. This automated process is the intended first action in a data discovery scenario where a formal file definition is not provided.
B. Set all of the data types to text and length longer than those specified. The profiler will tell you what they should be. This is a valid data discovery technique, but it is a manual override. The wizard's automatic detection (Option A) is the more direct and intended first step within the tool's workflow.
C. Import the fileinto a database table before profiling. This is incorrect as it introduces an unnecessary, time-consuming intermediate step. Informatica Data Quality is designed to profile flat files directly without needing a database staging area.
D. Change the code page of the file to UTF-8. This is incorrect because it makes an unsubstantiated assumption. The correct code page must be identified and selected during import, not arbitrarily changed, to prevent data corruption.
1. Informatica 10.5 Developer Tool Guide, Chapter 18: "Flat File Data Objects", Section: "Creating a Flat File Data Object", Page 368.
The guide details the "New Flat File Data Object" wizard. Step 6 states: "The wizard can generate columns from the file. The wizard can also detect the data type and precision for each column." This directly supports using the wizard to automatically select data types as the initial step.
2. Informatica 10.4.0 Data Quality User Guide, Chapter 2: "Profiles", Section: "Profile Creation Overview", Page 26.
This section explains that a profile runs on a source data object (like a flat file data object). This confirms that creating the data object is the prerequisite step. The most efficient way to create this object for discovery is described in Option A.
3. Informatica University, Data Quality 10: Developer, Specialist Certification Preparation, Module: "Analyst and Developer Collaboration", Section: "Creating Objects in the Developer".
Courseware materials emphasize using the Developer tool's wizards to streamline the creation of physical data objects from sources like flat files. The automatic metadata detection feature is highlighted as a key accelerator for data discovery and profiling projects.
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…
