Fact table is in normalized or de-normalized form?
No Answer is Posted For this Question
Be the First to Post Answer
How can you import tables from a database?
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
Explain what are components of reportnet?
How to join 3 database like flat file, oracle, db2 in informatrica?
What is aggregate fact table?
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,
Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?
Can we have more than one time dimensions in a Schema(Star or Snowflake)
What is a core dimension?
Can you brief about the Data warehouse project you worked on?
List down some of the real time data-warehousing tools?
Explain what are the vaious etl tools in the market?