Data Profiling using T-SQL queries

Question

Data Profiling using T-SQL queries

CeliweM

Valued Member

Points: 67
More actions
November 23, 2015 at 2:15 am

#313366

Hi
Please help, I am new on SQL, I need all the t-sql queries that can get me started with data profiling.
Your help will be appreciated.
Thanks.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Could you explain further what it is you're looking for?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

CeliweM Valued Member Points: 67 More actions · Answer 2

Hi

I need to do some of the following profiles using T-SQL queries, I have three tables that I need to profile: Are there any basic queries for the following profiles?

1. Value Inclusion Profile

2. Functional Dependency Profile

3. Candidate Key Profile

4.Column Pattern Profile

5. Column Value Distribution Profile

6.Column Statistics Profile

joeroshan SSChampion Points: 10377 More actions · Answer 3

If you are able to use SSIS, there is a task available.

https://msdn.microsoft.com/en-us/library/bb895263.aspx

----------------------------------------------------------------------------------------------------------------------------------------------------
Roshan Joe

Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]

CeliweM Valued Member Points: 67 More actions · Answer 4

Hi Roshan,

That would make my work a lot easier, I have checked a couple of videos. But sadly, we using t-sql queries and I don't even have visual studio installed.