1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / ambatisubramanyam

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 ?    11 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

in which situations do u go for scds ?

3 Answers   TCS,

My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?

6 Answers   Accenture,

What is limitations of truncate and load option

1 Answers   Cap Gemini,

which one is better either active or passive transformation in informatica

1 Answers  

Define Incremental Aggregation?

2 Answers  




How will u find weather dimension table is big in size of a fact table?

1 Answers  

What is an expression transformation?

0 Answers  

Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

0 Answers   IBM,

two types of data are there . one is mainframe and the other is ascii format . in informatica how can you get both the data in a single format in ascii .

2 Answers   TCS,

define galaxy repository in informatica

0 Answers  

How many mapplets u have created? and what is the logic used

5 Answers   Mind Tree,

how to calculate the optimum cache size in aggregator transformation?

1 Answers  

For more Informatica Interview Questions Click Here
Categories