This section covers key known limitations of .
NOTE: This list of limitations should not be considered complete.
The applies no fixed limits to the number of columns or rows that can be handled during transformation.
NOTE: During transformation, is designed to process data volumes of any size.
However, some important considerations:
See Sampling below.
Soft row limits do not affect the number of columns that are displayed. All available and visible columns are displayed. The number of rows may be affected by the number of columns.
Tip: Avoid creating and working with datasets that are wider than 1000 columns. Datasets that are wider than this recommendation may result in performance impacts in the .
valuestocols, will still be configured according to sample data at the time of that the step was added, instead at execution time. For example, all of the values detected in the sample are used to determine the columns of a
valuestocolstransform step based on the selected sample when the step was added.
The product supports a variety of global file encoding types for import.
NOTE: Some functions do not correctly account for multi-byte characters. Multi-byte metadata values may not be consistently managed.
For more specific limitations on each product edition, see .