What are the different types of fact tables used in data warehousing?
- 0 Answers
- 558 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Why joiner transformation does not allow the aggregator transformation and expression transformation to join
What is data analysis? Where it will be used?
Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?
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 difference between snow flake and star schema.
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.
Explain what is the advantages data mining over traditional approaches?
What are modeling tools available in the market?
What is the difference between static cache and dynamic cache?
Explain a mapping, session, worklet, workflow, mapplet?
Code the tables statement for a single-level (most common) frequency?
What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?
Teradata 
