Combine Primary Keys for Uniqueness Profiling in Information Steward

[kalpesh_pandey]

Hi, I would like to run Uniqueness profiling on my db but not on single column. My primary keys consist of 3-4 columns. Can I combine those primary keys and then run uniqueness i.e. can I combine multiple columns from a table and then run Uniqueness profiling.

Thanks

[paula_augedahl]

Uniqueness is tied to a single column.

The Views inside of IS doesn't appear to allow you to concatenate fields.  One thing that you might do is create  a View in the database itself where you combine these fields and then profile that view inside of Data Insight.

Hope this is helpful,

Paula