Profiling on partition table

[Anonymous]

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 

[Sebastiao_Qlik · Accepted solution]

Hi,

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

[Anonymous]

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