Free Informatica PR000041 Exam Dumps Questions & Answers

What function could be used to exchange 'i' with 'I' in the COMPANY port given the following expression?
functionname{1, COMPANY, 'i' , 'I')

• A.  INSTR
• B.  REPLACECHR
• C.  REG_REPLACE
• D.  CHOOSE

Based upon the graphic below, which answer correctly discribes the outcome of this workflow's execution given the start method: (The workflow is valid)
Workflows > Start Workflow

• A.  The Start task and the link will execute, while the session task will wait to execute
• B.  AII objects displayed will be executed
• C.  The Start task and link only will be execute
• D.  The Start task only will be executed

How does a single joiner transformation join data?

• A.  From 2 pipeline inputs
• B.  From n number of pipeline inputs assuming you have purchased the N-Joiner Option
• C.  none of the above
• D.  From 3 pipeline inputs

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

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

When the Transformation Scope is set to All Input, which group of transformations listed below will always cause an upstream Transaction Control transformation to become ineffective? (choose one)

• A.  Rank, Lookup, Aggregator
• B.  Union, Filter, Aggregator
• C.  Joiner, Rank, Sorter
• D.  Filter, Joiner, Rank