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
- 5541 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
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Write the advantages of partitioning a session?
What are the tasks that source qualifier perform?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What is meant by pre and post session shell command?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What is meant by query override?
What is lookup change?
How to load the data from people soft hrm to people soft erm using informatica?
What is sq transformation?
What is the cumulative sum and moving sum?
What are the differences between joiner transformation and source qualifier transformation?
What is the function of look up transformation?
Why do we need informatica?
Define mapping and session?
