Designer Core - Data Transformation Flashcards
What are the tools that are on this exam?
Cross tab, Summarize and Transpose
What does the Cross Tab tool do?
Creates 1 new value for each categorical value held in a single existing column, pivoting the data from a vertical layout to a horizontal layout
In the Crosstab tool, which aggregation options are available for columns with string data?
- Concatenate values
- Use first value associated with header
- Use last value associated with header
In the crosstab tool, which aggregation options are available for numeric data?
- Sum values
- Average values
- Use first or last value associated with header
If the incoming data set contains multiple data types when transposing data columns, the values will automatically convert to
The most robust data type to accommodate the various values, typically V-String
The Crosstab tool will replace special characters and spaces in headers with
Underscores (_), to increase speed and efficiency when processing
The Crosstab tool automatically sorts headers and groups in what order?
Ascending
What does the Transpose tool do?
Moves values held in multiple horizontal columns into a single column
What does the Summarize tool do?
It can perform a host of summary calculations, including summing, min and max, grouping, counting, string concatenating, math, spatial object processing, and much more
What does the Summarize tool do?
It can perform a host of summary calculations, including summing, min and max, grouping, counting, string concatenating, math, spatial object processing, and much more
True or False? The Summarize tool can apply summary processes to Spatial, String, and Numeric data types.
True
Which of the following function categories have Action Properties? Select all that apply.
Numeric, Reporting, None, String, and Finance
String and Finance