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
11195 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 types of transformations?

1018

In warehouses how many schemas are there?

1019

How to use procedural logic inside infromatica?

1147

How can we delete duplicate rows from flat files?

1171

Please let me know how to make encryption and decryption with example?

1862

COM components can be used in Informatica

2321

What do you mean by enterprise data warehousing?

1011

What is meant by lookup transformation? Explain the types of lookup transformation?

908

How can we store previous session logs?

1001

what is the Default Source Option For Update Strategy Transformation?

1176

Write the advantages of partitioning a session?

1222

What are the settings that you use to configure the joiner transformation?

1009

my source is junk data how will u remove that junk data by using unix please any one replay me

3658

generate date / time dimension in informatica

1077

What are the different lookup cache(s)?

1041