how to calculate sum(sal) with out using aggregator satge
Answer Posted / jz
just sql override in SQ t/r:
select col1..,sum(sal) from table_nme group by (col)
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?
Explain conformed fact?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
Explain what are the advantages data mining over traditional approaches?
What are the data types present in bo? What happens if we implement view in the designer n report?
Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?
Explain what is real time data-warehousing?
Explain how many ways you create ports?
What is data warehouse architecture?
After the generation of a report to whom we have to deploy or what we do after the completion of a report?
Explain difference between snow flake and star schema.
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.
Explain me what are data marts?
What is an error log table in informatica occurs and how to maintain it in mapping?
What is is the guidelines to build universe with better performance? R performance tuning issues of universes?