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
- 5425 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
How an expression transformation differs from aggregator transformation?
What are junk dimensions?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Design time, run time. If you don't create parameter what will happen
What is a sorter transformation?
What is joiner transformation?
what is size of u r database?
Mention a few design and development best practices for informatica?
What is the benefit of session partitioning?
How do you load only null records into target? Explain through mapping flow.
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Please let me know how to make Data masking in informatica..
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
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??
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
