Can anybady tell me , what is the aggrigate awareness.how to use it . could u plz give me the practical example.
Answer Posted / veda
Aggregate Awareness is a funtion used in caliculations
where it is implemented in complex queries to improve the
performance of sql transformation. Mostly we apply this
function for summary tables.
eg; year,quarter,month,week ,day
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
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?
Explain the difference between union and group?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
Explain which versions are used in the bo dashboard work?
What is the difference in creating filters in designer and business objects?
how to prepare the documentation in business objects and where to get the requirement?
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.
Explain what is the difference between business requirement document and use case document.
Which command using Query Analyzer will give you the version of SQL server and operating system ?
What is the difference between business requirement document and use case document.
what are the tables used in health care domain project and columns used in report?
Can anybody tell me what are the tuning problems?
What is the difference between absolute and relative div positioning?
What is the difference between datawarehousing and businessintelligence?