How to eliminate duplicate rows from flat file?
No Answer is Posted For this Question
Be the First to Post Answer
Select * from emp,dept,loc where emp.deptno left outer join dept.deptno and dept.locno=loc.locno. No need to consider the syntax but is it possible to have left outer join and equi join in the same SQL like this ? can we have right outer join and left outer join in the same SQL ---
1 Answers Principal Finance, PT Metalogix Infolink Persada,
explain about dirty dimension?
what is hybrid schema
What are the mapping paramaters and maping variables?
What is the purpose of cluster analysis in data warehousing?
Explain how many ways you create ports?
Explain vldb?
What is the advantages data mining over traditional approaches?
what is the diffrence between psa and idoc
What is factless fact schema?
How can we load the time dimension?
What is factless fact tables?