If we are using an aggregator but forget to mention the
group by port .what will be the output??
Answers were Sorted based on User's Feedback
No group by Port-
The AggTrans wil check for group by Column port up to last
column. No group by port was find,The AggTrans wil return
the last row only.
Every Column row wil check for Group by port done or not,
up to last row.
Finally (By default) last row will return.
Last Row still waiting for Group by port.,,,,
Thats why Group by prot is must.
Any Corrections,,,,,srinu.srinuvas@gmail.com
Is This Answer Correct ? | 57 Yes | 4 No |
Answer / kt
If we miss to enable any of the port as GROUP BY, the
aggregator will write the lat row of the table to the next
trnasformation.
Is This Answer Correct ? | 50 Yes | 1 No |
Answer / sheelendra
I agree with Srinu.
and It will return only one aggregated value for all input.
Is This Answer Correct ? | 13 Yes | 1 No |
Answer / g. manthiramoorthy
If we miss to enable any of the port as GROUP BY, the
aggregator will write the lat
row of the table to the next transformation
Is This Answer Correct ? | 11 Yes | 0 No |
Answer / g. manthiramoorthy
If we miss to enable any of the port as GROUP BY,
the aggregator will write the last row of the table to the
next transformation
Is This Answer Correct ? | 8 Yes | 0 No |
Answer / 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 |
Answer / uppala chary
first of all group by port G is mandatory ,if u don't
enable the group by port it wiil returns last record,and
enable the group by port it will return all the records.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / cooldude
It will behave like a passive transformation.All the rows
are passed witout any aggregation.
Is This Answer Correct ? | 8 Yes | 54 No |
how to connect two or more table with single source qualifier?
What are the types of groups in Router transformation?
split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar
1 Answers Cap Gemini, TCS, Wipro,
How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this
what is the look up transformation?
What do you understand by a term domain?
What is confirmed fact in dataware housing?
What is the difference between informatica 7.0 and 8.0?
what is mapping optimization? wat are the techniques for tat
I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .
Router T/R is active but some people are saying it is also passive which is exactly right?
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID anil643@gmail.com (or) kumar643@gmail.com