HCE-5920

You have a PDI job where you want to dynamically pass a table name to the Table input step of a transformation. You have replacedthe table name reference in the transformation’s Table input step with‘$(table_name)’ but when the transformation runs the table name is shown as ‘$(table_name)’ Which action will...

You need to load data from many CSV files into a database and you want to minimize the number of PDI jobs and transformations that need to be maintained. In which two scenarios is Metadata injection the recommend option? (Choose two.)A . When the files have a different structure andhave...

In a PDI transformation you are retrieving data from a large lookup table using a Database Lookup step from improve performance, you enable caching in the stepand use the Load all data from table option. In this scenario, which three statement s are correct about the data flow of the...

You are encryption your database connection password to use in the kettle. properties file. The output of the encr script is: Encrypted XYZABC123 In this scenario, which syntax is correct?A . DB_PASSWORD=Encrypted (‘XYZABC 123’)B . DB_PASSWORD=String(‘XYZABC123’)C . DB_PASSWORD=XYZABC123D . DB_PASSWORD=Encrypted XYZABC123View AnswerAnswer: A

You have multiple transformations that read and process data from multiple text files. You identity a series of steps that are common across transformations and you want to re-use them to avoid duplication of code. How do you accomplish this?A . Use the "Mapping (sub-transformation)' step containing the series of...

Which two statements are correct about the Repository Explorer? (Choose two.)A . You can create new jobs and transformations.B . You can move. rename, and delete jobs and transformations.C . You can upload JDBC drivers when defining JOBC connections.D . You can lock and unlock jobs and transformations.View AnswerAnswer: B,D...

You have instated the Pentaho server using an archive installation. You now want to change the server port. Which file do you modify?A . server.xmlB . repositories.xmlC . context.xmlD . slave-server-config.xmlView AnswerAnswer: A Explanation: Follow the instructions below to change the port through which the Pentaho Server runs: ✑ Stop...

you want to make a dynamic PDI transformation that is driven with variables that areloaded from a properties file. Which free form text fields within a step can be configured with variables?A . Any free form text field with a ''V'' next to itB . any free form text field...

You have slow-running steps in a PDI transformation and you notice that it is taking a long time for subsequent steps to get data and begin processing. Which action will help solve the problem?A . Reduce the value in the Nr’ of rows in rowset’ option on the Miscellaneous tab...

You need to design a PDI job that will execute a transformation andthen send an e-mail with an attached log of the transformation’s execution. Which two sets of actions will accomplish this task? (Choose two.)A . In the mail entry’s options, select the ‘Attach files to message’ option and select...