PR000041- Informatica PC Data Integration9.xDeveloper Set 2

Which of the following will not work when adding transformations to mappings?


Options are :

  • .From the Mapping menu, select Add Transformation
  • Right click and choose Add Transformation on the mapping
  • Click and drag the transformation onto the mapping
  • .Double click on the transformation in the transformation palette

Answer : Click and drag the transformation onto the mapping

PR000041- Informatica PC Data Integration9.xDeveloper Set 3

Which of the following statements is correct on workflow events?


Options are :

  • A user-defined event can be created in either the Event Wait or Event Raise task
  • A user-defined event can be created a-d raised in one workflow and then used In another
  • A predefined (or file-wait) Event Wait waits for a file to appear at the specified location. As soon as the file appears, it is deleted and the subsequent task will start.
  • A predefined (or file-wait) Event Wait task waits for a file to appear at the specified location. As soon as the file appears, the event succeeds and the file can be processed by the subsequent mapping

Answer : A predefined (or file-wait) Event Wait waits for a file to appear at the specified location. As soon as the file appears, it is deleted and the subsequent task will start.

Which of the following is not a function of Data Standardization?


Options are :

  • Standardization can remove or replace bad or inconsistent data
  • Standardization corrects and automatically updates the data in your source system
  • .Standardization converts data to standardized formats
  • .Standardization can remove "noise"

Answer : Standardization corrects and automatically updates the data in your source system

An Update Strategy transformation has the Forward Rejected Rows attribute unchecked. Which statement is correct and true?


Options are :

  • Records that are tagged for rejection are projected downstream to the next transformation so long as the ports are connected properly
  • Records that are tagged for rejection are dropped and not projected downstream to the next transformation
  • The Forward Rejected Rows attribute is only applicable when records are tagged for rejection upstream of the Update Strategy transformation
  • The Forward Rejected Rows attribute cannot be cleared after the transformation is created

Answer : Records that are tagged for rejection are dropped and not projected downstream to the next transformation

PR000041- Informatica PC Data Integration9.xDeveloper Set 4

Which two IDQ transformations can use parameters?


Options are :

  • Comparison
  • Decision
  • B & D
  • .Case converter
  • Address Validation

Answer : B & D

When applying a reference table in the Labeler in token mode which of the following statementsis correct?


Options are :

  • .Any items that do not appear in the reference table are not displayed in the output
  • Selecting Inclusive mode will output items that are present in the reference table under the label provided
  • Selecting Exclusive mode will exclude Items that are present in the reference table
  • The order of the reference tables defined will not impact your results displayed

Answer : Selecting Inclusive mode will output items that are present in the reference table under the label provided

Which of these statements is true about Data Rules?


Options are :

  • Data Rules must be run against the entire data set they are defined upon
  • Data Rules can only be run on data in the project in which they were created
  • .Once created a Data Rule cannot be changed...it can only be deleted and re-created
  • .A Data Rule created in the Analyst will appear as a mapplet with an Expression Transformation in the Developer

Answer : Data Rules can only be run on data in the project in which they were created

PR000041- Informatica PC Data Integration9.xDeveloper Set 5

Which two of the following values can be parameterized in the Match transformation?


Options are :

  • Scoring methods
  • Threshold values
  • Match Field Inputs
  • A & C

Answer : A & C

Which of following statements is valid for Dynamic lookups?


Options are :

  • It is possible to update and delete records in a dynamic lookup
  • Dynamic caching cannot be enabled on a lookup that returns multiple rows per search
  • A dynamic lookup must be cached and persistent
  • A dynamic lookup can only be used with insert mappings, i.e. no update strategies are allowed and the session should be configured as Insert

Answer : Dynamic caching cannot be enabled on a lookup that returns multiple rows per search

If the inputs to the Edit Distance Strategy below are 'john' and NULL, what will the resultingmatch score be?



Options are :

  • .0.5
  • 1.2
  • .0
  • 1

Answer : 1

PR000041- Informatica PC Data Integration9.xDeveloper Set 6

What functionality does Data Quality Assistant provide?


Options are :

  • Bad record management
  • Automatically consolidates data
  • A & C
  • .Consolidate duplicates into master record

Answer : A & C

Which of the following will Impact the total amount of time it takes to execute a column profiling process?


Options are :

  • All of the above
  • .Number of Columns in the file
  • Number of Rows in the source data
  • .Amount of memory and speed of the processor on the server

Answer : Number of Rows in the source data

Which of the following Is NOT true of Aggregate functions?


Options are :

  • You can calculate a single value for all rows in a group
  • You can use operators to perform arithmetic within the function
  • You can place an aggregate function in a variable port
  • You can add a filter condition to calculate values for specific rows In the selected ports

Answer : You can place an aggregate function in a variable port

Which of the following is not true when it comes to creating and updating Reference Tables?


Options are :

  • Reference Tables maintained in the Analyst and Developer tools are stored in separate repositories
  • Reference Tables can be imported and exported using the Developer Tool
  • .All except Un-Managed Reference Tables can be updated through the Reference Table Manager in the Analyst
  • .Reference Tables can be updated from a Value Frequency list in the Developer

Answer : .All except Un-Managed Reference Tables can be updated through the Reference Table Manager in the Analyst

Assuming that the Master Pipeline has 5 fields, two of which are part of the join condition and that all fields are connected downstream to the next transformation, how many fields are in the index and data cache files?


Options are :

  • 2 fields are in the index cache and 3 fields are in the data cache
  • 2 fields are in the index and 5 fields are in the data cache
  • 3 fields are in the index cache and 2 fields are in the data cache
  • . 5 fields are in the index cache and 3 are in the data cache

Answer : . 5 fields are in the index cache and 3 are in the data cache

The HTTP Transformation supports which HTTP Methods?


Options are :

  • DELETE
  • B & C
  • GET
  • POST

Answer : B & C

In the Case Converter transformation which of the following is not a valid Case Transform?


Options are :

  • Lower Case
  • .Upper Case
  • Sentence Case
  • .Toggle merge Case

Answer : Sentence Case

The Pattern Parser is used in conjunction with which transformation


Options are :

  • Exception
  • Standardizer
  • Labeler
  • Token Parser

Answer : Labeler

Referring to an Unconnected Lookup transformation: Which one of the following is true?


Options are :

  • An unconnected lookup can return multiple rows while a connected lookup may return only one
  • Both connected and unconnected lookups can return multiple rows
  • Both connected and unconnected lookups can return only one row
  • An unconnected lookup may return only one value while a connected lookup may return multiple rows

Answer : An unconnected lookup may return only one value while a connected lookup may return multiple rows

Informatica Data Quality 10 Developer Specialist Set 1

An Unconnected Stored Procedure can run in the following fashions?


Options are :

  • As a Pre-Session SQL command
  • From an expression
  • All of the above
  • As a Post-Session SQL command

Answer : All of the above

Given a Union transformation with 2 input groups, which statement is correct and true?


Options are :

  • When merging the 2 groups of data together, the Union transformation will remove duplicate rows.
  • Both input groups must have matching ports. The precision, datatype, and scale must be identical across both input groups.
  • The port names in each input group can be named the same.
  • . Either input group can have a port that does not match the other input group. The precision, datatype, and scale does not have to be identical across both input groups.

Answer : Both input groups must have matching ports. The precision, datatype, and scale must be identical across both input groups.

Subqueries can be used in the SQL override for uncached lookup transformations


Options are :

  • True
  • False

Answer : False

Which attributes of a reusable Expression transformation can be edited within the Mapping Designer workspace


Options are :

  • The transformation's name or the tracing level
  • The transformation's name, one of its port's default values or the tracing level
  • The transformation's name, one of its port's default values, the tracing level or a Metadata Extension
  • The transformation's name is the only attribute that can be changed

Answer : The transformation's name or the tracing level

Referring to the Sequence Generator transformation, which statement is correct and true?


Options are :

  • The default ending value for a PowerCenter 9.x Sequence Generator is 2,147,483,647
  • The Sequence Generator contains a single input port that represents the initial starting point of the sequence
  • The NextVal column produces the next number in the sequence
  • The cycle check box on the properties tab turns on a feature that randomizes the numbers but still produces a unique set of numbers for the sequence

Answer : The NextVal column produces the next number in the sequence

Please choose one of the following. In a static, non-multi-row lookup


Options are :

  • None of the above
  • If a lookup search finds the search value in the lookup data but discovers that the fields that are being returned from the search are null, then the row from which the search is produced is dropped so that a balanced pipeline can be produced
  • . lf a lookup search does not find a value in the search data, then the row from which the search is produced is dropped so a balanced pipeline can be produced
  • If the lookup finds two records that match the search key, it will return two records

Answer : None of the above

Which combination of Transaction Control transformation and target type results in an invalid mapping?


Options are :

  • Relational target
  • MS target
  • XML target
  • Dynamic MQ Series target

Answer : MS target

A user needs to compare mappings across two folders using the comparsion tool in PowerCenter Designer. What does the user account need in order to successfully complete the comparsion action? (Given that the user account has been granted the ability to use PowerCenter Designer)


Options are :

  • Read permissions on the two folders
  • Mappings cannot be compared across folders using PowerCenter Designer
  • Read permissions on the two folders as well as have both folders opened
  • Full access (Read, Write and Execute permissions) on both folders

Answer : Read permissions on the two folders as well as have both folders opened

Assuming that the value of Fl is 12 as it enters the decode statement, which of the following decode statements will produce the value V?



Options are :

  • Option A
  • Option A & C
  • OptionB
  • OptionC

Answer : Option A & C

Which one of the following transformations may be unconnected In a valid mapping?


Options are :

  • Lookup, stored procedure, external procedure
  • Lookup, stored procedure, Java
  • Transaction control, Java, lookup
  • Java, lookup, transaction control

Answer : Lookup, stored procedure, external procedure

Which of the following is true about database connections?


Options are :

  • Connections may only be created in the Workflow Manager for PowerCenter Repositories and only in the Developer for the MRS
  • Connections may be created in the Administrator for the MRS and in the Workflow Manager for PowerCenter Repositories
  • PowerCenter connections may be created In either the Administrator or the Workflow Manager
  • MRS connections may be created in either the Workflow Manager or the Administrator

Answer : Connections may only be created in the Workflow Manager for PowerCenter Repositories and only in the Developer for the MRS

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions