New answers tagged oracle-sql-developer
The green bug you're seeing (look closely) means the package have been compiled with DEBUG option. It is also seen on bare procedures and functions. It is a coincidence they don't expand - maybe a bug (duh) in SQLdeveloper :) On mine, these expand without problem.
NB:- I am giving the sql syntax of MS SQL Server(i am only familiar with).I guess you can develop from it. First, you have to select the data using sql. Usually UNION returns only distinct raw SELECT LastName, FirstName, Address, City, State, Zip FROM HospitalOne UNION SELECT LastName, FirstName, Address, City, State, Zip FROM HospitalTwo ORDER BY ...
You would need to something called data cleansing. There are tools within which such logic can be written for example IDQ or IBM QualityStage if not then you would need to write Stored Procedures while doing the ETL to de-duplicate/clean up the data and then load the final list into DWH.
Top 50 recent answers are included