Data transformed successfully from Source table to target table. Now how you wil

Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer

Question Posted / bk19

2 Answers
4454 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Data transformed successfully from Source table to target table. Now how you will ensure that the da..

Answer / abhinaw prakash

You can write the query using both the source and target tables.

You can use the NOT IN and MINUS keyword.

Also you can make a mapping using both the tables and
generate a report on the missing records.

Is This Answer Correct ?

5 Yes

0 No

Data transformed successfully from Source table to target table. Now how you will ensure that the da..

Answer / snjsngh15

Select count(*) from tableA A
Where not exist( select 1 from tableA D
Where B.id=D.id)
Minus
Select * from tablesB B
Where not exist( select 1 from tableB c
Where B.id=C.id)
Or
Select * from Table A
Minus
Select * from Table B

Is This Answer Correct ?

0 Yes

0 No

Post New Answer