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
- 5422 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 is a surrogate key?
What are the differences between a connected lookup and unconnected lookup?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Explain the use of aggregator cache file?
What is olap (on-line analytical processing?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What is a predefined event?
What is the way to execute pl/sql script using informatica mapping?
What is the scenario which compels informatica server to reject files?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
what is informatica metadata?
In which transformation you cannot drag ports into it?
Quickly characterize reusable change?
