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 aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?

2 Answers  

---

What are the new features of the server manager in the informatica 5.0?

1 Answers  

---

Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?

2 Answers   Deloitte,

---

How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????

2 Answers   TCS,

---

In SCD type 2 if we had select date range. then suppose we had inserted today's date(eq. date is 30 aug 2010) then start date will be today's date(30 aug 2010) what will be the end date,we cant leave it blank?

2 Answers   Cognizant, emc2,

---

---

what is degenerated dimension?

1 Answers   IBM,

---

How to read data from flat file source if the data is in paragraph format?

2 Answers   Wipro,

---

what is the predefined port in dynamic lookup

2 Answers  

---

I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?

3 Answers  

---

What are the challenges you have faced in your project?

1 Answers   Cognizant, Infosys,

---

what is the purpose of surrogate key and diff between primary key&surrogate key

1 Answers   Cap Gemini,

---

How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.

1 Answers   Cognizant,

---