we r using aggregator with out using groupby?
- 7 Answers
- 20891 Views
- HSBC, Principal Finance, I also Faced
- E-Mail Answers
Answer Posted / srikanth nallapati
if we are not using group by also u get the result from agg
traceformation but u get only one one total column result
Ex:deptno sal
10 1000
20 3000
30 4000
10 5000
in aggr trance i am not use group by but i create one new
column like sum_of_sal here logic implementation is sum(sal)
this sum sal is linked with target table then u get result
as like above description.... if u try to send more then
one column from this aggre tranc means it's fail..
i think it's work....
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How to elaborate tracing level?
Enlist the advantages of informatica.
What are the issues you have faced in your project? How did you overcome those issues?
Why is sorter an active transformation?
Explain dynamic target flat file name generation in informatica
What is dimensional table? Explain the different dimensions.
what are the Methods For Creating Reusable Transformations?
how to create user defined function (udf) in informatica
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Could you explain what is enterprise data warehouse?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What is the difference between router and filter?
Enlist some properties of sessions.
Explain incremental aggregation in informatica
