PR000041- Informatica PC Data Integration9.xDeveloper Set 1

Select the item that is not a common symptom of data quality problems


Options are :

  • Lack of trust and agreement in reporting
  • .high customer satisfaction
  • .Supply-chain 'out of stock' situations
  • .Failure of IT projects

Answer : Lack of trust and agreement in reporting

PR000041- Informatica PC Data Integration9.xDeveloper Set 2

Which of these statements is correct concerning a Lookup transformation's persistent cache?


Options are :

  • persistent cache is stored on disk, to refresh the cache the disk files must be deleted manually
  • A persistent cache is stored on disk, and must be named to make it useable in multiple mappings
  • A persistent cache can only be used by one mapping
  • When the Integration Service cannot find the persistent cache file and the recache property is not set, the session fails

Answer : A persistent cache is stored on disk, and must be named to make it useable in multiple mappings

When importing a flat file into a project. Developer and Analyst Tool work exactly the same


Options are :

  • TRUE
  • FALSE

Answer : TRUE

Which of the following techniques could be used to filter data read from a flat file source?


Options are :

  • Create a valid condition in the Filter attribute of the flat file's Source Qualifier
  • Place a Filter transformation directly after the flat file's Source Qualifier
  • An Expression transformation with an output port's expression defined to filter records
  • An Expression transformation with all of the output port's default values set to blank

Answer : Place a Filter transformation directly after the flat file's Source Qualifier

PR000041- Informatica PC Data Integration9.xDeveloper Set 3

How is Accelerator content installed?


Options are :

  • .It is installed using the importer available in the Content Management service
  • .The file extracted onto the server and it is automatically picked up after restarting the services
  • .Using the IDQ content installer.
  • .It is imported through Developer.

Answer : .The file extracted onto the server and it is automatically picked up after restarting the services

In the TO_CHAR (date) function, what do the format strings D, DD, and DDD produce?


Options are :

  • Each produces numerical day of week
  • Numerical day of week, day of month, and day of year respectively
  • Day of week, day of month, and Julian date since 4713 B.C. 00:00:00 (midnight) respectively
  • Character day of week, character day of month, and character day of year respectively

Answer : Numerical day of week, day of month, and day of year respectively

Which of these statements on worklets is correct?


Options are :

  • A worklet does not have to contain a Start task
  • Worklets can be nested
  • A worklet can be executed separately
  • A worklet must be a reusable object

Answer : Worklets can be nested

PR000041- Informatica PC Data Integration9.xDeveloper Set 4

What is the best approach to implementing Address Validation in version 9.1?


Options are :

  • .Run the addresses into the AV transformation without modification.
  • .Take an iterative approach and review AV output. Determine why addresses did not validate and attempt to resolve the issue prior to running them in the AV transformation.
  • Canada Post defines the SERP certification standard for software applications that validate Canadian addresses
  • Remove all punctuation before sending the address to the AV transformation

Answer : Canada Post defines the SERP certification standard for software applications that validate Canadian addresses

Which Informatica option provides solutions to common data quality issues in a country, region,or industry?


Options are :

  • populations
  • mapplets
  • dictionaries
  • accelerators

Answer : dictionaries

What versions of PowerCenter can an IDQ 9.1 mapping be exported to?


Options are :

  • .PC 8.11, PC 8.51 and PC 8.6
  • PC 8.51 and higher
  • PC 8.6.1 and higher
  • .All PC versions

Answer : .PC 8.11, PC 8.51 and PC 8.6

PR000041- Informatica PC Data Integration9.xDeveloper Set 5

During a project export, typically what will the output be from the export?


Options are :

  • .An xml file containing all the mapping/mapplet/object definition and a zip file containing all the reference data if required
  • .An xml file containing all the mapping/mapplet/object definition
  • The contents of each Project (including the dependent reference tables) in a zip file
  • Projects will be exported to an .irob file

Answer : .An xml file containing all the mapping/mapplet/object definition and a zip file containing all the reference data if required

Which statement on workflows is correct?


Options are :

  • A workflow can contain multiple start points
  • Another workflow cannot be executed from within a workflow
  • In a default configuration, a workflow parameter file overrides all parameter files in underlying sessions
  • In a default configuration, a workflow must contain at least one session task

Answer : In a default configuration, a workflow parameter file overrides all parameter files in underlying sessions

Two pipelines (A & B) are entering a Joiner transformation with each having a record size of 100 bytes. Pipeline A has a total of 1000 records and Pipeline B has a total of 1,000,000 records. Which pipeline should be designated the master pipeline?


Options are :

  • Pipeline B
  • Both Pipelines should be cached for performance reasons
  • Pipeline A
  • . Pipeline B if and only if Pipeline A is sorted

Answer : Pipeline A

PR000041- Informatica PC Data Integration9.xDeveloper Set 6

When profiling, why is it good to sort the value lists in both ascending and descending order?


Options are :

  • None of the above.
  • .There is no specific reason. It is simply a step of an ordered best practice approach.
  • Values with leading spaces or punctuation will typically sort to the top or bottom making them easier to identify
  • It is good because it is easier to determine if a field is numeric or text.

Answer : It is good because it is easier to determine if a field is numeric or text.

Which port types are applicable to the Stored Procedure transformation?


Options are :

  • Output
  • Return
  • All of the above
  • lnput

Answer : All of the above

Which of the following statements is true regarding DQ for Excel?


Options are :

  • DQ for Excel allows .xls files be used as source and target objects in mappings.
  • .In order to be able to use DQ for Excel, both PowerCenter and Data Quality Developer must be installed.
  • .DQ for Excel enables non Informatica users to benefit from data quality rules by consuming and applying data quality rules directly from MS Excel data/ worksheets.
  • .DQ for Excel can be used in any version of Excel.

Answer : .DQ for Excel enables non Informatica users to benefit from data quality rules by consuming and applying data quality rules directly from MS Excel data/ worksheets.

A customer wants to be able to review data on the overall quality of each record, which technique should be used


Options are :

  • Scorecarding
  • Standardization
  • Matching
  • Grading

Answer : Standardization

What function could be used to exchange 'i' with 'I' in the COMPANY port given the following expression?

functionname{1, COMPANY, 'i' , 'I')


Options are :

  • INSTR
  • CHOOSE
  • REPLACECHR
  • REG_REPLACE

Answer : REPLACECHR

Which of the following are supported file types, from which, an XML definition can be imported?


Options are :

  • XSD
  • DTD
  • All of the above
  • XML

Answer : All of the above

Which definition describes Column Profiling?


Options are :

  • Colum profiling automatically recognizes all functional and other dependencies in all tables, in particular the primary keys
  • Column profiling is the process of creating a normalized schema for your target system
  • Column profiling is the process of looking at every distinct value to determine the true minimum, maximum, data type, pattern and other important information about each attribute
  • Column profiling identifies the attributes for referential integrity

Answer : Column profiling is the process of creating a normalized schema for your target system

In the Expression transformation graphic below, what is the value of the PREVIOUS_STATE port for row 2, given that the value for the STATE port was 'CA' for row 1?


Options are :

  • Value of the PREVI0US_STATE port is based upon its declared default value
  • NULL
  • 'CA'
  • STATE

Answer : 'CA'

Where does Scorecarding fit into the data quality process?


Options are :

  • At the end of the process only to prove the value of the data quality tool
  • .At the start of the process only to assess current data quality levels
  • At the start and during regular intervals of the process to measure on-going data quality levels
  • Not at all - Scorecardlng is a separate process

Answer : At the start and during regular intervals of the process to measure on-going data quality levels

What types of profiling can be performed in the Developer Tool in Data Quality


Options are :

  • Column, Join Analysis, Mid Stream and Comparative Profiling
  • Column and Join Profiling only
  • .Column, Join Analysis, Mid Stream, Comparative, Primary and Foreign Key and Overlap Profiling
  • .Column Profiling, Primary Key Inference, Dependency Inference

Answer : Column, Join Analysis, Mid Stream and Comparative Profiling

Accelerators provide which of the following


Options are :

  • Demonstration data objects
  • .Demonstration mappings
  • Rules
  • All of the above
  • Profiles

Answer : All of the above

You have just standardized values in a field and you would like to review how the modified dataappears alongside the original data. Which profiling method would best be suited for this?


Options are :

  • Column Profiling
  • Comparative Profiling
  • Mid Stream Profiling
  • Join Analysis Profile

Answer : Mid Stream Profiling

The IDQ and PowerCenter repositories all share the same schema.


Options are :

  • TRUE
  • FALSE

Answer : FALSE

Which transformation would you typically use to remove noise, symbols or words?


Options are :

  • Standardizer
  • Parser
  • Comparison
  • Decision

Answer : Standardizer

What happens to the records when corrections are made and a status of Accept is assigned?


Options are :

  • .Records are corrected and are sent to an Accepted DB table
  • Records are accepted and are pushed out to Target/Production DB
  • The corrections are committed to the Staging DB and record is automatically pushed into another DB
  • The corrections are committed to the Staging DB and an UPDATED_STATUS of Accepted is assigned to the record

Answer : The corrections are committed to the Staging DB and record is automatically pushed into another DB

Given the picture shown below:

Identify all of the true and correct statements listed below. Note: The red (or gray) arrow points at the line in question.

The line on the left hand side of the picture which connects PRODUCT TO PRODUCT_COST :


Options are :

  • Describes a secondary data flow needed for a sub-select process between PRODUCT AND PRODUCT_COST
  • B & D
  • Can be created within Informatica PowerCenter
  • Describes an INNER JOIN between PRODUCT AND PRODUCT_COST
  • Describes a LEFT OUTER JOIN between PRODUCT AND PRODUCT_COST

Answer : B & D

In which of the following selections are all of the transformations active?


Options are :

  • Stored Procedure, Joiner, Router
  • Router, Update Strategy, Joiner
  • Update Strategy, Expression, Aggregator
  • Expression, Router, Joiner

Answer : Router, Update Strategy, Joiner

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions