how to calculate sum(sal) with out using aggregator satge
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / dj
we have to add 2 new ports in "expression"
1)variable-- declare sum(sal)
2)output port- cal this variable
Is This Answer Correct ? | 3 Yes | 4 No |
Answer / tejeswara rao potnuru
using expression transformation we can find
Is This Answer Correct ? | 3 Yes | 8 No |
What are the types of dimensional modeling?
What is an OLAP (On-line Analytical processing) system?
Explain what are components of report studio?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
Explain what is the difference between powerplay transformer and power play reports?
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 the differences between normalizer and normalizer transformation?
What is the function of surrogate key in data warehousing?
1.WHAT IS DATA MART ?
Why null values are mapped as 0 in fact tables?
How can we do data cleaning?