What are data modeling and data mining? Where it will be used?
No Answer is Posted For this Question
Be the First to Post Answer
What are the various transformation available?
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,
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
what are different ways of loading data to data warehouse using oracle?
What is the goal of optimizer?
What is the function of surrogate key in data warehousing?
What is the data type of the surrogate key?
Explain degenerate dimension table?
What are the key columns in Fact and dimension tables?
how to find unique records in informatica level
Explain reference cursor?
What is is the guidelines to build universe with better performance? R performance tuning issues of universes?