Dynamic filter during run time

[Gary]

User Need :
We wish to set the extraction of data from a table based on filter statements expressed by an administrator in a flat file.

Constraints:
The number of filter statements is not fixed. There is at least one filter statement.
The format of this flat file is fixed.
Flat file filter format : FilterName ; FilterNumber; FilterStatement x


Question :
How to implement these Filter Statements dynamically? It sis similar to the parameter sets in Datastage that check the parameter values during the run time.

[MFGF]

User Need :
We wish to set the extraction of data from a table based on filter statements expressed by an administrator in a flat file.

Constraints:
The number of filter statements is not fixed. There is at least one filter statement.
The format of this flat file is fixed.
Flat file filter format : FilterName ; FilterNumber; FilterStatement x


Question :
How to implement these Filter Statements dynamically? It sis similar to the parameter sets in Datastage that check the parameter values during the run time.

It's very difficult to say without knowing how the filter statements are expressed and how they relate to the data you are reading.

One option might be to suck the filter data into a lookup, and reference this from a fact build that reads in all the rows from the table. If there is a match you can deliver the row and if not you can allow it to be rejected. Without knowing more it's not possible to say if this is workable in your case, though.

MF.