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
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 might you approve all mappings in the archive all the while?
what is SDLC way of code development?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
How can you define user defied event?
difference between informatica 8.1.1 and 8.6
Explain pushdown optimization $pushdownconfig parameter - informatica
Write the different tools in the workflow manager?
What are active and passive transformations?
How to do unit testing in informatica? How to load data in informatica ?
What is different between the data warehouse and data mart?
Write the advantages of partitioning a session?
What is substr in informatica?
Explain the shared cache and re-cache?
What is a router transformation?
Explain direct and indirect flat file loading (source file type) - informatica