Which of the following Is NOT true of Aggregate functions?A . You can place an aggregate function in a variable portB . You can add a filter condition to calculate values for specific rows...
Using the Properties view of a Session task from the Workflow Monitor, the reason for a session's failure can possibly be determined?A . TrueB . FalseView AnswerAnswer: A
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 projected downstream to the next transformation so long as...
What function could be used to exchange 'i' with 'I' in the COMPANY port given the following expression? functionname {1, COMPANY, 'i' , 'I')A . CHOOSEB . REPLACECHRC . REG_REPLACED . INSTRView AnswerAnswer: B
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 . Filter, Joiner, RankB . Union,...
Referring to an Unconnected Lookup transformation: Which one of the following is true? (choose one)A . An unconnected lookup can return multiple rows while a connected lookup may return only oneB . Both connected...
Which of following statements is valid for Dynamic lookups?A . Dynamic caching cannot be enabled on a lookup that returns multiple rows per searchB . A dynamic lookup can only be used with insert...
A user needs to compare mappings across two folders using the comparsion tool in Power Center Designer. What does the user account need in order to successfully complete the comparsion action? (Given that the...
Which command line tool would you use to execute a workflow?A . infasetupB . infacmdC . pmcmdD . pmrepView AnswerAnswer: C
The user creates a mapping by using aggregator transformation. The aggregator transformation receives sorted input from sorted transformation. What is the dafault partition type for aggregator transformation?A . Pass-throughB . Hash auto-keysC . Not...
