PR000041- Informatica PC Data Integration9.xDeveloper Set 4

Transformation: Referring to Active and Passive characteristics - Select the statement which is correct and true


Options are :

  • A transformation is active if it does not change the number of rows in the pipeline
  • If a transformation's Active property is cleared or not enabled, the transformation becomes passive
  • A passive transformation will not change the number of rows in the pipeline
  • Transformations can be active and passive at the same time

Answer : A passive transformation will not change the number of rows in the pipeline

Can you use a Decode function to perform multiple searches based on a single search value?


Options are :

  • Yes
  • Yes, but only if the port being searched Is sorted first
  • No
  • Yes, but only if the port is downstream of a router transformation

Answer : Yes

Which of the following statements regarding mapplets are correct and true?


Options are :

  • Every mapplet must have at least 1 Input transformation as well as 1 Output transformation
  • A mapplet can contain a Normalizer transformation
  • A mapplet can contain a target definition
  • . A mapplet can contain a source definition as well as a source qualifier

Answer : . A mapplet can contain a source definition as well as a source qualifier

PR000041- Informatica PC Data Integration9.xDeveloper Set 5

Refering to the Lookup transformation, which statement is correct and true?


Options are :

  • The lookup condition is designated in the ports tab interface via the "L" check box
  • The lookup condition defines the fields that are used in the search of the data
  • The lookup condition defines how much memory each of the two caches will consume
  • The lookup condition is limited to only the equal operator

Answer : The lookup condition defines the fields that are used in the search of the data

Which of the following statments are valid for Active and Passive Transformations?


Options are :

  • A passive transformation will not change the number of rows in the pipeline
  • A & D
  • Transformations can be active and passive at the same time
  • A transformation is active if It rearranges the order of the rows in the pipeline

Answer : A & D

What is a pipeline lookup transformation?


Options are :

  • A lookup associated with the Source Qualifier or an Application source such as JMS or SAP
  • A pipeline lookup does not exist
  • A lookup cache split over pipelines of a partitioned mapping
  • A lookup created using a pipeline which contains a target

Answer : A lookup associated with the Source Qualifier or an Application source such as JMS or SAP

PR000041- Informatica PC Data Integration9.xDeveloper Set 6

The constant DD_INSERT may be used in an expression within which transformation or transformations?


Options are :

  • Expression and Update Strategy
  • Update Strategy and Lookup
  • Expression, Aggregator, and Update Strategy
  • Update Strategy

Answer : Update Strategy

A workflow has a session task. Both workflow and session each have been assigned a different parameter

file. Which value will be set for $$ParameterValue in the session when using the following two parameter files?"


Workflow Parameter file:

  [Global] $$ParameterValue=l

[Session] $$ParameterValue=2

Session Parameter file:

[Global] $$ParameterValue=3

[Session] $$ParameterValue=4


Options are :

  • 3
  • 2
  • 4
  • 1

Answer : 1

Of the statements below, which best describes the underlying process taken when a user connects to a PowerCenter Repository Service for the first time? For the puposes of this question, the PowerCenter Developer is the only PowerCenter client application running, there are 2 nodes in the domain, node 1 is a gateway node and node 2 is a worker node. The PowerCenter Repository Service is running on the worker node.


Options are :

  • The user connects to the service manager of the gateway node, and after authentication and authorization, is re- Assigned to the Repository Service
  • The user first connects to the PowerCenter Integration Service and then after authentication and authorization, is connected to the PowerCenter Repository Service
  • The user connects to the service manager of the worker node that is running the Repository Service, is then authenticated, authorized, and connected to the PowerCenter Repository Service
  • The user connects directly and immediately to the Repository Service

Answer : The user connects to the service manager of the gateway node, and after authentication and authorization, is re- Assigned to the Repository Service

What is the first column of the bad file?


Options are :

  • Row Indicator
  • Column Indicator
  • Overflow Indicator
  • Reject reason

Answer : Row Indicator

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


Options are :

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

Answer : Number of Rows in the source data

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 :

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

Answer : Mid Stream Profiling

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


Options are :

  • TRUE
  • FALSE

Answer : TRUE

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



Options are :

  • 1
  • 1.2
  • .0
  • .0.5

Answer : 1

Informatica Data Quality 10 Developer Specialist Set 1

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


Options are :

  • .All except Un-Managed Reference Tables can be updated through the Reference Table Manager in the Analyst
  • Reference Tables can be imported and exported using the Developer Tool
  • Reference Tables maintained in the Analyst and Developer tools are stored in separate repositories
  • .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

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

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

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 :

  • REG_REPLACE
  • CHOOSE
  • INSTR
  • REPLACECHR

Answer : REPLACECHR

Informatica Data Quality 10 Developer Specialist Set 2

Which port types are applicable to the Stored Procedure transformation?


Options are :

  • Output
  • lnput
  • Return
  • All of the above

Answer : All of the above

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
  • The Forward Rejected Rows attribute cannot be cleared after the transformation is created
  • 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

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

Which two IDQ transformations can use parameters?


Options are :

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

Answer : B & D

PR000041- Informatica PC Data Integration9.xDeveloper Set 1

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


Options are :

  • accelerators
  • populations
  • mapplets
  • dictionaries

Answer : dictionaries

Which of these statements is true about Data Rules?


Options are :

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

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

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


Options are :

  • .Standardization can remove "noise"
  • 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

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

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


Options are :

  • .Run the addresses into the AV transformation without modification.
  • Canada Post defines the SERP certification standard for software applications that validate Canadian addresses
  • .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.
  • 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

An Unconnected Stored Procedure can run in the following fashions?


Options are :

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

Answer : All of the above

Accelerators provide which of the following


Options are :

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

Answer : All of the above

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


Options are :

  • Standardization
  • Scorecarding
  • Matching
  • Grading

Answer : Standardization

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


Options are :

  • DTD
  • XML
  • All of the above
  • XSD

Answer : All of the above

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
  • Pipeline A
  • Both Pipelines should be cached for performance reasons
  • . Pipeline B if and only if Pipeline A is sorted

Answer : Pipeline A

Where does Scorecarding fit into the data quality process?


Options are :

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

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

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions