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
What are the new features of Power Center 5.0?
What is the difference between informatica 7.0 and 8.0?
What is rank transform?
What are the various types of transformation?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
without table how to come first record only in oracle?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What is dimensional table?
Briefly define a session task?
Why sorter is an active transformation?
Explain the difference between mapping parameter and mapping variable?
what is index?how it can work in informatica
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
COM components can be used in Informatica