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

How can we update a record in the target table without using update strategy?

0 Answers  

can we have to do changes in session property when we are dynamically generating target files?

3 Answers   Wipro,

How union transformation is active ?

2 Answers   Puma,

which transformation uses cache?

3 Answers   Keane India Ltd,

How do you create single lookup transformation using multiple tables?

6 Answers   TCS,

What are the databases that informatica can connect to windows?

0 Answers  

What are the advantages of using informatica as an etl tool over teradata?

0 Answers  

How can you display only hidden files in UNIX

4 Answers   Cognizant, L&T,

Design a mapping to load the cumulative sum of salaries of employees into target table?

0 Answers   Informatica,

How can u insert o ne row in the target if that row does not exists in the target and update if it exists

6 Answers   Accenture,

in which situations do u go for scds ?

3 Answers   TCS,

Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u

3 Answers