You can use the UNION and UNION ALL operators in queries. The operators combine the result sets of two or more SELECT statements.

For more information, see the

Informatica Data Archive 6.2 Data Vault Query Reference

.

You can include parameters in queries. A parameterized query uses parameters or placeholders in place of values. When you define the SQL statement, you can use placeholders in place of the values. When you run the SQL statement, supply the values for the placeholders in a separate statement.

For more information, see the

Informatica Data Archive 6.2 Data Vault Query Reference

.