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
- 5339 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
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
what is the hint? how to use it to reduce the query processing in program?
Which transformation should we use to normalise the COBOL and relational sources?
Explain what are the different versions of informatica?
What are the new features of informatica 9.x developer?
Explain the different dimensions.
How to load data in informatica ?
What are the differences between source qualifier and joiner transformation?
What is dimensional table? Explain the different dimensions.
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is joiner transformation in informatica?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What is the need of an ETL tool?
Make a note of the quantity vaults made in informatica?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
