Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?
Answer Posted / ranjan
You can use the minus keyword
Source table name is A
Target table name is B.
Query can be
select * from B
minus
select * from A
or else you can do a minus from A to B.
select * from A
minus
select * from B
Inthis way you can find the mismatch
(Note: This is just one way pf comparing)
Thanks,
Ranjan
Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Can we create multiple integration service on single repository?
What does update strategy mean, and what are the different option of it?
How can you define user defied event?
What are the restrictions of union transformation?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Explain dynamic target flat file name generation in informatica
Suppose we do not group by on any ports of the aggregator what will be the output?
How to improve the performance of a session using sorter transformation?
define galaxy repository in informatica
What is parallel processing in informatica?
Where is metadata stored?
How to create the source and target database connections in server manager?
Differentiate between a database and data warehouse?
What is workflow? What are the components of the workflow manager?