Data transformed successfully from Source table to target table. Now how you wil

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 / bk19

2 Answers
5465 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Data transformed successfully from Source table to target table. Now how you will ensure that the da..

Answer / abhinaw prakash

You can write the query using both the source and target tables.

You can use the NOT IN and MINUS keyword.

Also you can make a mapping using both the tables and
generate a report on the missing records.

Is This Answer Correct ?

5 Yes

0 No

Data transformed successfully from Source table to target table. Now how you will ensure that the da..

Answer / 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

More Informatica Interview Questions

HOW TO DELETE A RECORD FROM FLAT FILE

6 Answers TCS,

Hi Friends, How i could convert a cobol file (VSAM) into the flat file? How i could edit a cobol source file (VSAM)? I want to introduce few columns in the source file and finally the target should be in the Cobol itself. Kindly suggest me friends. Thanks in Advance, Innai

1 Answers Infosys, Saksoft,

How can repository reports be accessed without sql or other transformations?

0 Answers

Useful UNIX commands regular/frequently used

1 Answers Deloitte,

I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com

119 Answers Accenture, Gcs, TCS,

Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.

1 Answers Accenture,

Explain pmcmd command usage in informatica

0 Answers Informatica,

What is a node in Informatica?

0 Answers

Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

4 Answers IBM, Infotech,

hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.... i dont need to use sequence generator transformation..... how do u achieve this???

3 Answers HP,

Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

6 Answers IBM,

what is mean by throghput? in informatica

3 Answers Cap Gemini,

For more Informatica Interview Questions Click Here