What is Cognos script editor?
No Answer is Posted For this Question
Be the First to Post Answer
What is real-time datawarehousing?
How to export mappings to the production environment?
Tell me the Top 10 features of oracle that supports datawarehousing.
Whether dimension table can have numeric value?
What are snapshots? What are materialized views & where do we use them?
Explain a mapping, session, worklet, workflow, mapplet?
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,
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
How many types of facts and what are they?
What are the types of SCD?
What is called dimensional modelling?
What are cursors?