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?

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

How to generate or load values in to the target table based on a column value using informatica etl tool.

852


What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5245


How can a transformation be made reusable?

869


Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1806


i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

1913


what is INFORMATICA TESTING process

2072


Explain pushdown optimization and types in informatica

877


How do you manage the Parameter files while migrating your data from one environment to another environment?

796


What is aggregator transformation in informatica?

754


What are roles and groups and benefits of using them?

800


1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

1917


What is rank transformation in informatica

952


What is the benefit of partitioning a session?

905


What is intricate mapping?

822


I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1071