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

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

4 Answers   ABC, Cap Gemini,

in which situations do u go for sequence generator ?

2 Answers   TCS,

What are the disadvantages of Sequence Generator T/R?

3 Answers   Zensar,

Can you access a repository created in previous version of Informatica?

1 Answers  

What is a filter transformation?

0 Answers  




what is the architecture of any Data warehousing project?

5 Answers   IBM,

What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?

1 Answers  

Why use shortcuts(Instead of making copies).

1 Answers  

What are the mapping parameters and mapping variables?

0 Answers   Informatica,

i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression

3 Answers  

write a query following table bookid language 1234 english 1234 french 1234 spanish 1235 english i want the output are bookid lang1 lang2 lang3 1234 english french spanish 1235 english null null

1 Answers   TCS,

What is olap (on-line analytical processing?

0 Answers  

For more Informatica Interview Questions Click Here
Categories