18 Questions
What happens if a failure occurs during any iteration?
The failure link is followed immediately
What does the Stop On Condition property allow you to do?
Stop the iteration based on a specified condition
How are conditions specified in the Simple mode of creating conditions?
Using a no-code Condition UI
What must be done for iterations to run concurrently?
Define all 'Variables to Iterate' as copied variables
What limits the maximum concurrency of iterations?
$2\times$ the number of processors on your cloud instance
What does the Mode property determine?
The method of creating conditions
In which mode is there an editor where users must manually write the condition using SQL?
Advanced mode
When is combining conditions available?
Only when Mode is set to Simple
What is the primary purpose of the Grid Iterator component?
To enable you to run an attached component multiple times, each time with different values set on any number of variables
How can you detach the Grid Iterator component from an attached component?
Right-click on the attached component and select 'Disconnect from Iterator'
What is the maximum number of iterations allowed for all iterator components?
5000
What is the default setting for the 'Break on Failure' property of the Grid Iterator component?
No: Attempt to run the attached component for each iteration, regardless of success or failure
How can you iterate over more than one component using the Grid Iterator component?
Put the components into a separate orchestration job or transformation job and use a Run Transformation or Run Orchestration component attached to the iterator
What is the purpose of the 'Grid Variable Mapping' property in the Grid Iterator component?
To map grid column names to variable names that can be referenced by the attached component
What is the purpose of the 'Grid Variable' property in the Grid Iterator component?
To specify the grid variable that will be used to drive the iterations
What is the purpose of the 'Sequential mode' in the Grid Iterator component?
To ensure that the iterations always proceed in the same order as the data is held in the grid variable
What is the purpose of the 'Name' property in the Grid Iterator component?
To provide a human-readable name for the component
How can you define a new grid variable to be used with the Grid Iterator component?
Use the 'Grid Variables' section of the component's properties to define a new grid variable
Learn about the Grid Iterator component, which allows users to loop over values of a simple sequence in order to run an attached component multiple times with different variable values. To attach the iterator to another component, use the blue output connector and link to the desired component.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free