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
- 11169 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
How to do the error handling of if ur source is flatfiles?
Define filter transformation?
can you please explain me pre session and post session options?
wf dont have integration severances how you can run?
What's the layout of parameter file (what does a parameter file contain?)?
Clarify the aggregator change?
What is pmcmd command?
What are the conditions needed to improve the performance of informatica aggregator transformation?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What is decode in static cache?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Scheduling properties,whats the default (sequential)
What are the issues you have faced in your project? How did you overcome those issues?
What differs when we choose the sorted input for aggregator transformation?
