Manual Data profiling queries

Database
Enthusiast

Manual Data profiling queries

Hi,

If anyone have manual data profiling queries Please send me .

Thanks in Advance

Nagesh

5 REPLIES
Enthusiast

Re: Manual Data profiling queries

My Mail id is :nagesh.dwh123@gmail.com

Enthusiast

Re: Manual Data profiling queries

Hi Nagesh,

I used Teradata Profiler and Ab Initio Data profiler before. However, manual is a real pain.

Few years back, I used manual .

Believe me it is a pain. I used unix script too sometimes.

You have so many.
There are so many functions: like, uppercase, lowercase, substr, trim etc.

SELECT COUNT(*) AS First_cap FROM table WHERE INITCAP(column) = column;

SELECT MAX(column) AS max_value FROM table;
SELECT MIN(column) AS min_positive_value FROM table WHERE column > 0;
SELECT MIN(column) AS lowest_negative_value FROM table WHERE column < 0;
SELECT COUNT(*) AS num_values FROM table WHERE column IS NOT NULL;
SELECT COUNT(*) AS num_nulls FROM table WHERE column IS NULL;

others like SELECT regexp_replace.

Cheers,
Raja
Enthusiast

Re: Manual Data profiling queries

Thanks Raja for u r help. I need one more query to find the data pattren ( INT,CHAR,DECIMAL and DATA). If any query Please help me

Enthusiast

Re: Manual Data profiling queries

Hi Nagesh,

You can use help column dbname.tablename.* to get the required data.

Cheers,

Raja

Enthusiast

Re: Manual Data profiling queries

In STG table we are defining all columns are Varchar only .But to Target we need to define base upon the data