Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Profiling on partition table

Hi Users, @Ganshyam @rhall  @scorreia  @xdshi  @TRF 

 

I have oracle DB where all most all the tables are partitioned (different partitions range,list,hash ....)

So how can I use profiling on partitioned table(I can't use a where clause to specify the partition)

 

is there a way that I can use some thing like Table_name partition(US) in Talend DQ ?

 

and how to do profiling to get group by result

for example : I wan to find null email count country wise(is this possible ?)

Query is like :

select country,count( of invalid emails)(--this is via some logic of regex)

from table group by country 

 

Labels (2)
1 Solution

Accepted Solutions
2 Replies
Sebastiao_Qlik
Employee
Employee

Hi,

 

I would try to create a user-defined indicator: https://help.talend.com/reader/HqPypUO_cLctKv_dAWcgFw/5T0c8bWewY4Xnz84z0Vptg

Anonymous
Not applicable
Author

@scorreia  Thanks scorreia it helped me for do group by with UDI's