1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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?

Question Posted / jeyakumar.uv

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

What are the components of workflow manager?

1 Answers  

Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?

2 Answers   TCS,

How can you recognise whether or not the newly added rows in the source r gets insert in the target ?

2 Answers  

what are the reusable tasks in informatica ?

11 Answers   CTS, HP, IBM, TCS,

Describe data concatenation?

1 Answers  

What is a predefined event?

1 Answers  

Hi, Can someone send me the DWH and Informatica FAQ's at priti.singh84@gmail.com Thanks in Advance, preeti

1 Answers   Accenture, Patni,

Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3

3 Answers   CTS,

Differentiate between source qualifier and filter transformation?

1 Answers  

Why do we use DSS database for OLAP tools?

2 Answers  

Can you copy the batches?

3 Answers  

what is the difference between mapplet & stored procedure?

1 Answers  

For more Informatica Interview Questions Click Here
Categories