Metadata Structure of Stream
This is a step to read the metadata of the incoming stream.
Metadata Structure
Option |
Definition |
|---|---|
Step Name |
The name of the step |
Output Row |
Do you want to output the rows (Y/N) |
Field for Row |
If "output row" is selected, name the field that will contain the output row data |
How to use this step
You can create an input step from a database of your choice and then create an input hop to this step.
You may choose to create inputs from two different databases which *should* have the same structure and use a "Merge rows (diff)" step to compare the structure. If doing this, note that the case of field names are sometimes different and that the data types are also detected differently from different database engines. It may help to sort the result by "position" to help identify where a column mismatch causes a "new" and "deleted" record.