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
- 11592 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
Explain in detail about scd type 1 through mapping.
What is expression transformation?
What do you mean by blocking transformation?
Difference between Data and Index Caches?
What is the difference between router and filter?
have u done any performance tuning? how u ll do?
what is degenerated dimension?
is it possible to index the data in cache of lkp transformation ?
What is the session task and command task?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What is target load order?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How do you migrate data from one environment to another?
What are the new features of Power Center 5.0?
What is sequence generator transformation in informatica?
