Doubt In Qa

[venkat726]

How to vaildate data when data is loaded from one source to other

Count in source should match count in target adi oka method

inka emina unaya

[subbayya]

oka SQL query rasuko....like sum, average on some columns test that on both source and target.....

[IamNotTrouble]

no of rows columns match chustavu.....
avi match ayithe field values kuda check chestavu.......

[venkat726]

okay

[subbayya]

inko validation..... aa data lo date column edanna vunte

select to_char(date_column_name, 'yyyy'), count(*) from table_name where date is not null group by to_char(date_column_name, 'yyyy');

same aa 'yyyy' vunnachota 'dd' kuda petti test chesuko date wise data kuda vasthadi... source count and target count match avuthundo ledo chusuko saripothadi...

[150bryant]

first match selection count
then individual records of primarykey
then individual fields if required

[venkat726]

thanks for the help