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
- 4911 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are multi-group transformations?
While migrating the data from one environment to another environment how would you manage the connections?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
How to update or delete the rows in a target, which do not have key fields?
Explain your project of banking domian.
Which is the t/r that builts only single cache memory?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What are the different versions of informatica?
Explain how many types of dimensions are available in informatica?
What are the informatica performance improvement tips
What is union transformation?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is a repository manager?
what is $$$$?
