You can use the minus keyword Source table name is A Target table name

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 / ranjan

5 Answers
11427 Views
I also Faced
E-Mail Answers

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain the scenario which compels informatica server to reject files?

1162

How to load the data from people soft hrm to people soft erm using informatica?

1008

What is pmcmd command?

1104

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1635

wat are deployement groups in informatica, how it will be used for developers

1714

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1244

can we override a native sql query within informatica? Where do we do it? How do we do it?

1047

What is meant by lookup transformation?

1099

What is the meaning of up gradation of repository?

1980

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8218

Explain your project of banking domian.

1650

expain about the tune parameters?

2411

explan ur project architecture?

2061

Difference between Data and Index Caches?

1135

What is depict expression change?

1114