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
- 2 Answers
- 4703 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
How many numbers of sessions can one group in batches?
In warehouses how many schemas are there?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What are the popular informatica products?
How can you generate reports in informatica?
Why do we need informatica?
Explian the Process of deployment groups in informatica
Where can we find the throughput option in informatica?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
lookup transformation with screenshots
What is the format of informatica objects in a repository?
Informatica Checkpoints
What is a rank transform?
What is Cognos script editor?
Can we change Dynamic to Static or Persistent cache? If so what happens?
