Select count(*) from tableA A Where not exist( select 1 from tableA D W

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

Question Posted / snjsngh15

2 Answers
5332 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

Please Help Members By Posting Answers For Below Questions

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7114

What are the tuning techniques you applied during your last project

1965

Explain the types of lookup transformation?

978

can we override a native sql query within informatica? How do we do it?

1051

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

970

expain about the tune parameters?

2338

Explain pushdown optimization and types in informatica

1015

What is union transformation in informatica?

1097

What is a transaction control transformation?

1143

What is dimensional table?

1002

waht type of interface is used for testing the data in informatica

2190

What is an expression transformation in informatica?

963

Different circumstance which drives informatica server to expel records?

915

update strategy transformation in informatica

1014

Explain sessions?

978