If your client approaches you and says that he wants to
create a Datawarehouse, and provides just the info
regarding his source systems.
What are all the neccessary actions one is supposed to
take/understand and get back with a comprehensive document
which convinces the client to proceed with the DW
initiative.
What are all the documents we need to provide the client?
Answer / -chaitanya
-First we need to discuss our company standards with the
client though the client is already aware of the standards,
-Need to collect critical to quality points from the
customer.and discus inscoper and outscope of the project.
-Design a datamodel and check with users by setting
iterative meetings till the business and the lead are on
same page.
| Is This Answer Correct ? | 3 Yes | 7 No |
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
what is the difference between aggregate table and fact table ? how do you load these two tables ?
What is the differences between star and snowflake schemas?
In a star schema, are foreign key constraints between facts and dimensions neccessary?
in general which algorithms for used?
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,
wht is degenerated dimension ?it's uses?
Explain what is fact less fact table? Where you have used it in your project?
What are the various methods of getting incremental records or delta records from the source systems?
How can you implement many relations in star schema model?
What are aggregate fact tables ? why they are needed? give an example
What are the types of dimensional modeling?