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



Source having one lakh record and loaded into target. Then, how can i compare records will loaded in..

Answer / 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

Source having one lakh record and loaded into target. Then, how can i compare records will loaded in..

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

Source having one lakh record and loaded into target. Then, how can i compare records will loaded in..

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

Source having one lakh record and loaded into target. Then, how can i compare records will loaded in..

Answer / rakesh

What if A and B eixist in different Databases..?

Is This Answer Correct ?    0 Yes 0 No

Source having one lakh record and loaded into target. Then, how can i compare records will loaded in..

Answer / rakesh

if source n targer exist in
different databases you can
create Database link in any of
the database for other one..

create database link "dblink
name"
connect to schemaname
identified by password
using 'Database name';

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

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

1 Answers  


Quickly characterize reusable change?

0 Answers  


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.

0 Answers  


What exactly mentioned in High level design document.can somebody explain me sequentialy.

1 Answers   IBM,


What are the basic needs to join two sources in a source qualifier?

4 Answers  






How can you access the remote source into your session?

1 Answers  


what are presession,postsession success and postsession failure commands ?

1 Answers  


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.....

3 Answers   TCS,


Why do you use Mapping Parameter and mapping variable?

0 Answers  


What is an Integration service in Informatica?

0 Answers  


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

9 Answers   Deloitte,


What happens if we dont select data driven option?

2 Answers   Zensar,


Categories