Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


i have an aggregater in my mapping and no group by port on
any column and i ampassing 100 rows through aggregater,so
how many rows i will get as out put from aggregater

Answers were Sorted based on User's Feedback



i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows thr..

Answer / rob

last row only

Is This Answer Correct ?    30 Yes 1 No

i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows thr..

Answer / sreenivas

it will return 100th row of the source if group by port is
not selected in aggregator


thanks,
sreenivas

Is This Answer Correct ?    10 Yes 0 No

i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows thr..

Answer / rukmini

it will return last row from 100 rows

Is This Answer Correct ?    9 Yes 0 No

i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows thr..

Answer / pooja

all rows will come, since its not grouped. if its group by,
then last row will be out.

Is This Answer Correct ?    3 Yes 14 No

i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows thr..

Answer / shankar

session becomes failed

Is This Answer Correct ?    0 Yes 17 No

Post New Answer



More Informatica Interview Questions

what is plsql table?

2 Answers  


Hi, What is version control in Informatia ? Can anyone just give an idea or introduction about this? Advance Thanks

2 Answers   IBM,


In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query

8 Answers   Cap Gemini,


What is the status code in stored procedure transformation?

0 Answers   Informatica,


IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?

2 Answers  






Can any body tell about the (UTC) unit test cases with the examples in informatica.

4 Answers  


what is Partitioning ? where we can use Partition?

2 Answers   IBM, TCS,


What does refresh system mean, and what are its distinctive choice?

0 Answers  


In my sourse i have like ename,gender vasu,male geetha,female ram,male suma.female kesav,male in my output i need male,female vasu,geetha ram,suma kesav

5 Answers  


My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this

2 Answers  


What happens to map if we alter the datatypes between source and its corresponding source qualifier?

0 Answers  


what is casual dimension?

6 Answers   IBM,






Categories