Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 5 Answers
- 11454 Views
- I also Faced
- E-Mail Answers
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
in reporting we add some new objects,how we get the count of the newly added objects to the report
What is meant by query override?
Define joiner transformation?
How would you copy the content of one repository to another repository?
What is persistent lookup cache?
What are the types of schemas we have in data warehouse.
How to use procedural logic inside infromatica?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Explain the pipeline partition with real time example?
While migrating the data from one environment to another environment how would you manage the connections?
What is a mapplet/worklet in informatica?
what is the size of your data warehousing?
Which development components of informatica have the highest usage?
Mention few power centre client applications with their basic purpose?
What is rank index in rank transformation?
