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
- 5459 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
Clarify the utilization of aggregator cache record?
What are data-driven sessions?
How do you convert single row from source into three rows into target?
Why do we need informatica?
What is workflow? What are the components of workflow manager?
How to generate sequence numbers?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What is aggregator transformation in informatica?
How can we update a record in the target table without using update strategy?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What is workflow manager?
What are the static cache and dynamic cache in informatica?
What is the difference between a connected look up and unconnected lookup?
How to generate or load values in to the target table based on a column value using informatica etl tool.
generate date / time dimension in informatica
