Please help me solve my issue.its been long time i am trying to resolve the issue.
I am using Oracle 9i, crystal 8.5.I am working on data validation across the DB's.I need to compare the data between source (sybase), staging(oracle) and target(oracle).The view has been made for source and tagert in stating.Source is the correct data and the data is migrated from source to staging and target also.I have made a link between source to staging and source to target with id and date fields.I am using outer join.There are 18000 records amount them 17000 records are correct and from the 17000 records , the record are repeating.Not sure why.
select a.id,a.date,a.reason,b.id,b.date,b.reason,c.id,c.date,c.reason from table1 a ,table2 b, table3 c where
a.id =b.id (+) and a.date =b.date (+) and
a.reason=b.reason (+)
union select a.id,a.date,a.reason,b.id,b.date,b.reason,c.id,c.date,c.reason from table1 a ,table2 b, table3 c where
a.id (+) =b.id and a.date (+) =b.date and
a.reason(+) =b.reason
I need out put like
id date reason
1 1/1/09 test
2 test2
2/2/09
I am using Oracle 9i, crystal 8.5.I am working on data validation across the DB's.I need to compare the data between source (sybase), staging(oracle) and target(oracle).The view has been made for source and tagert in stating.Source is the correct data and the data is migrated from source to staging and target also.I have made a link between source to staging and source to target with id and date fields.I am using outer join.There are 18000 records amount them 17000 records are correct and from the 17000 records , the record are repeating.Not sure why.
select a.id,a.date,a.reason,b.id,b.date,b.reason,c.id,c.date,c.reason from table1 a ,table2 b, table3 c where
a.id =b.id (+) and a.date =b.date (+) and
a.reason=b.reason (+)
union select a.id,a.date,a.reason,b.id,b.date,b.reason,c.id,c.date,c.reason from table1 a ,table2 b, table3 c where
a.id (+) =b.id and a.date (+) =b.date and
a.reason(+) =b.reason
I need out put like
id date reason
1 1/1/09 test
2 test2
2/2/09