we r using aggregator with out using groupby?
- 7 Answers
- 20001 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
What is DR strategy for Informatica project?
How to generate sequence numbers?
r u done any partitions in ur project?
What is decode in static cache?
How do you remove duplicate records in informatica? And how many ways are there to do it?
can anyone suggest best free Talend data integration training online
list out all the transformations which use cache?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Why sorter is an active transformation?
What will be the approach?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
how to load dimension table and fact table. plz tell me the steps.
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
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?
