Preface
Informatica Developer
The Model Repository
Searches in Informatica Developer
Connections
Physical Data Objects
Flat File Data Objects
Logical View of Data
Viewing Data
Application Deployment
Application Patch Deployment
Application Patch Deployment Example
Continuous Integration and Continuous Delivery (CI/CD)
Object Import and Export
Appendix A: Data Type Reference
Appendix B: Keyboard Shortcuts
Appendix C: Connection Properties

Developer Tool Guide

10.4.0
- 10.5.6
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1

Back Next

Select Distinct

You can select unique values from sources in a customized data object or a relational data object instance with the select distinct option. When you enable select distinct, the Data Integration Service adds a SELECT DISTINCT statement to the default SQL query.

Use the select distinct option to filter source data. For example, you might use the select distinct option to extract unique customer IDs from a table that lists total sales. When you use the relational data object in a mapping, the Data Integration Service filters data earlier in the data flow, which can increase performance.

Rename Saved Search

Table of Contents

Developer Tool Guide

Developer Tool Guide

Select Distinct

Select Distinct