Pipeline parameters:
Parameters are defined at the pipeline level, and cannot be modified during a pipeline run. Pipeline parameters can be used to control the behavior of a pipeline and its activities, such as by passing in the connection details for a dataset or the path of a file to be processed.
DATASET PARAMETERS
Every pipeline and data flow requires dataset, if you have a database with multiple tables in it, instead of creating new dataset for using each of them, dataset parameters can be used to pass the table names at run time.
You will need to create a dataset without mentioning table name while creating it
Parameters will be required to be added in the parameters tab. In the following example for creating azure sql dataset I have added two parameters, one for the schema name and other for the name of the table.