What is an aggregator transformation? it is active why cant
it be passive explain?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / rajan raorane
1)Agregator T/R is used to perform summary calcluation
2) It is Active bcoz the output of this T/R is not equal to
input
Is This Answer Correct ? | 2 Yes | 2 No |
Answer / suneelkumar.dasari
C in active T/R the total no.of input records wil be changed(i.e the total input records wont come),but in passive t/r the total no of input records are not changed,and we can add some extra columns.But in Active also we can add columns.
Is This Answer Correct ? | 2 Yes | 4 No |
I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
What are the different options available for update strategy?
When we are using Dynamic Cache,which options we will select in session level?
What is IQD file?
Design a mapping to load a target table with the following values from the above source?
I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?
difference between shortcut and reusable transformation?
differnece between joiner and a look up(please don't give just definitions)....i mean in which scenario it is better to use joiner and in which scenario better o use lookup ??
hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.
what is service oriented architecture in Informatica 8 version
1 Answers Cap Gemini, IBM, Systech, TCS,
How do you Merge multiple Flat files for example 100 flat files with out using Union T/F