Sign Up Login


  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

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 will u get 1 and 3rd and 5th records in table what is the query in oracle please help me

16 Answers   Cap Gemini, IBM,

Can any body tell about the (UTC) unit test cases with the examples in informatica.

4 Answers  

TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?

6 Answers   HP, TCS,

Which transformation should we use to normalise the COBOL and relational sources?

0 Answers   Informatica,

What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1

4 Answers   IBM,

I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?

5 Answers   Syntel,

how can u approach u r client

2 Answers   CTS,

How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?

2 Answers  

What is diff joiner and lookup

4 Answers   BirlaSoft,

If u r using dynamic cache lookup port will be thier in thet which option u will select

1 Answers   HCL,

how to get flatfile containg 10 records half records one target another half another target

2 Answers  

What does update strategy mean, and what are the different option of it?

0 Answers  

For more Informatica Interview Questions Click Here
Categories