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
- 5452 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
list out all the transformations which use cache?
What is main use of mapplet?
What is workflow? What are the components of workflow manager?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What if the source is a flat-file?
Can we override a native sql query within informatica?
How many number of sessions can one group in batches?
Performance tuning in UNIX for informatica mappings?
How can informatica be used for an organization?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Explain the etl program with few examples.
Difference between Target-based loading and constraint-based loading?
design of staging area?
What could be the possible resons of locks by user?
