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?
Answers were Sorted based on User's Feedback
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 |
Answer / abhinaw prakash
If both exist in same database then you can use NOT EXIST
function to find out the missing rows.
If both exist in diff databases then you can join them using
joiner and compare the rows in expression and Raise a Flag
for not matching rows.You can then use filter and pass only
the non matching rows into the target.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / abhinaw prakash
We can use lookup transformation to stay away from these
problem and can lookup the target columns befor entering the
data.
Is This Answer Correct ? | 1 Yes | 0 No |
I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me
Quickly characterize reusable change?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What exactly mentioned in High level design document.can somebody explain me sequentialy.
What are the basic needs to join two sources in a source qualifier?
How can you access the remote source into your session?
what are presession,postsession success and postsession failure commands ?
HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....
Why do you use Mapping Parameter and mapping variable?
What is an Integration service in Informatica?
How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this
What happens if we dont select data driven option?