How to filter data without using the Filter Transformation?
The source Data can be filtered from the Source Transform in the Source Properties.
As shown in the below figure use the where clause property to filter the data without using the Filter Transformation
Steps for the above Scenario:
- Create a Dataflow Drag source and target. Map the Attributes in the Attribute mapper.
- Select the source and go to properties, click on the expression editor symbol to open expression editor and give the proper filter condition.