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

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.

Answer / abhinaw prakash

We can use lookup transformation to stay away from these
problem and can lookup the target columns befor entering the
data.

Answer / rakesh

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

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';

IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ?

4 Answers   HP,

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2 Answers  

What are the different types of schemas?

11 Answers   ITC Infotech,

What is an unconnected transformation?

0 Answers   Informatica,

without using emailtask how will send a mail from informatica?

3 Answers  

how to join two flat file if they have diff. structure?how to join one relational and one flat file?

4 Answers   Wipro,

Whats the difference between informatica powercenter server, repositoryserver and repository?

0 Answers  

Can we use unconnected lookup as dynamic lookup?

5 Answers   ITC Infotech, TCS, Wipro,

How to generate sequence numbers using expression transformation?

0 Answers   Informatica,

wht is cdc?how to use it in creation of mappings?

6 Answers   HSBC,

WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?

7 Answers   Target,

How to find from a source which has 10,000 records, find the average between 500th to 600th record?

3 Answers