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 questions
Answer options
A: Allow the wizard in Developer to automatically select the data types when creating the data objects. Correct answer
B: Set all of the data types to text and length longer than those specified. The profiler will tell you what they should be.
C: Import the fileinto a database table before profiling.
D: Change the code page of the file to UTF-8.
Correct Answer:
A. Allow the wizard in Developer to automatically select the data types when creating the data objects.
Explanation

The 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.

Why Incorrect

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.

References

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.

Scroll to Top