If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
What is the difference in creating filters in designer and business objects?
Explain in detail about type 2(scd),
Explain what is the difference between business requirement document and use case document.
What is the functional & architectural differences between business objects and web intelligence reports?
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
Explain about a task that really tested your analytical abilities?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
Explain the data types present in bo and what happens if we implement view in the designer and report?
Explain is data mart?
Explain what task is 98% of the required work of a business analyst?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
Difference between b.o 5.1 and 6.1b?