Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5371 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
What is incremental aggregation?
What is informatica powercenter repository?
How many number of sessions can one group in batches?
What is blocking transformation?
if we have a delimiters at unwanted places in a flat file how can we over come those.
How can we improve session performance in aggregator transformation?
What are the types of data warehouses?
What are the main features of Oracle 8i with context to datawarehouse?
Why is sorter an active transformation?
without table how to come first record only in oracle?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What are the data movement modes in informatica?
Where are the source flat files kept before running the session?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
lookup transformation with screenshots
