Interested to Buy Any Domain ? << Click Here >> for more details...
If we are using an aggregator but forget to mention the
group by port .what will be the output??
- 11 Answers
- 34073 Views
- Nomura, TCS, I also Faced
- E-Mail Answers
Answer Posted / vikneswaran
output is single record.for examples
col1
1
1
1
2
2
2
3
3
4
if i use group by and sum(col1) ...
output
col1
3
6
6
4
if i didn't use group by but same agg function
output
col1
19
| Is This Answer Correct ? | 10 Yes | 7 No |
Post New Answer View All Answers
How many input parameters can exist in an unconnected lookup?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
How can we update a record in the target table without using update strategy?
What is a joiner transformation and why it is an active one?
How can we delete duplicate rows from flat files?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Can anyone tell me the new features in Informatica 9 Version?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
How can we use batches?
What is the need of etl tools?
Scheduling properties,whats the default (sequential)
What is confirmed fact in dataware housing?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Design a mapping to load the cumulative sum of salaries of employees into target table?
