- All Exams Instant Download
Which action will correct this issue?
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...
In which two scenarios is Metadata injection the recommend option?
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 this scenario, which three statement s are correct about the data flow of the ‘Database Lookup step?
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...
In this scenario, which syntax is correct?
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
How do you accomplish this?
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.)
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...
Which file do you modify?
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...
Which free form text fields within a step can be configured with variables?
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...
Which action will help solve the problem?
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...
Which two sets of actions will accomplish this task?
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...
