Interested to Buy Any Domain ? << Click Here >> for more details...
What is an aggregator transformation? it is active why cant
it be passive explain?
- 3 Answers
- 18214 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / mike
Well an aggregator transformation is an active connected
transformation which is used to convert detailed values in
to summary values by using aggregator functions like sum,
avg, max, min etc...if a mapping contains aggregator
transformation the informatica server executes the
expression each for every group of record. The aggregator
transformation is based on four parameters
1)groupby ports
2)group expression
3)stored inputs
4)incremental aggregation
As every one knows an aggregator transformation is active
because it executes less out put than no of inputs(detailed
values in to summarized values)...
By the definition an active transformation is the
transformation in which the no of outputs will be less than
inputs...
by the definition an passive transformation is the
transformation in which the no of outputs equals to the no
of inputs...
corect me if i was wrong....
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What you know about transaction control transformation?
During the running session, output files are created by informatica server. Enlist few of them.
How do you update the records with or without using update strategy?
What does role playing dimension mean?
What are the tuning techniques you applied during your last project
Explain the scenario which compels informatica server to reject files?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
Explain informatica architecture - version 8 / 9
Explain the types of lookup transformation?
How can we use mapping variables in informatica? Where do we use them?
What is incremental aggregation?
What is the difference between a repository server and a powerhouse?
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?
what is SDLC way of code development?
