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
How to generate or load values in to the target table based on a column value using informatica etl tool.
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
How can a transformation be made reusable?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
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
what is INFORMATICA TESTING process
Explain pushdown optimization and types in informatica
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is aggregator transformation in informatica?
What are roles and groups and benefits of using them?
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?
What is rank transformation in informatica
What is the benefit of partitioning a session?
What is intricate mapping?
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.