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

What are slowly changing dimensions?

5 Answers   Informatica, Verinon Technology Solutions,

How big was your fact table

0 Answers  

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

2 Answers   IBM,

How to extract sap data using informatica? What is abap? What are idocs?

0 Answers  

Mention few advantages of router transformation over filter transformation.

0 Answers  

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.

5 Answers  

what r the transformations that r not involved in mapplet?

8 Answers   Wipro,

wht target override?wht advantages it has compare to target update?

2 Answers   Polaris,

What is galaxy shema

2 Answers   CGI,

What is confirmed dimension with scenario

1 Answers   HCL,

How can we improve session performance in aggregator transformation?

0 Answers   Informatica,

Why we use stored procedure transformation?

4 Answers