QUESTIONS WITH SOLUTIONS GRADED A+
◍ What does entering "*" do with an input file? Answer: It brings in
anything that starts with the characters before the "*" and anything
after it
◍ What does entering "?" do with an input file? Answer: It brings in
anything that starts with the characters before the "?" plus one
character
◍ What are the limits for the data layout preview window in the
Input Data tool? Answer: 100 records or fewer in wide files
◍ How do you convert an Output Data Tool to an Input Data Tool?
Answer: 1.) Right-click the Output Data tool you want to convert to
an Input Data tool.
2.) Select Convert To Input Data.
◍ What are the 3 ways to add the Browse tool to the workflow?
Answer: -Drag a Browse tool to the canvas, and connect it to an
upstream tool.
-Right-click on a tool on the canvas and select Add Browse After.
-Use the Shift+Ctrl+B keyboard shortcut and select the tools in a
workflow.
, ◍ Without the browse tool, up to how much data shows in the
Results window? Answer: 1 MB of data
◍ How do you disable a browse tool? Answer: -Select a random
point on the canvas to display the Workflow - Configuration window.
-In the configuration window, select Runtime.
-Check Disable All Browse Tools to make the Browse tools in the
workflow unavailable. To enable Browse tools, uncheck Disable All
Browse Tools.
◍ What happens in the Configuration Window of the Browse Tool if
a column's data type is not compatible with data profiling? Answer:
"No Profiling Available" message will display
◍ What happens in the Configuration Window of the Browse Tool if
there is only one value in each column? Answer: "Only one value"
message displays
◍ What happens in the Configuration Window of the Browse Tool if
each value in the columns is unique? Answer: "All values are unique"
message displays
◍ In the Configuration Window of the Browse Tool, what are the two
categories you can filter based on? Answer: Fields (columns) and
Data Type