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

What is Code Page Compatibility?

1 Answers  


SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

0 Answers   Infotech,


Explain the difference between mapping parameter and mapping variable?

0 Answers  


My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.

3 Answers   Cognizant,


Explain sql transformation in script mode examples in informatica

0 Answers   Informatica,






How can you define a transformation? What are different types of transformations in Informatica?

10 Answers  


What is a code page?

0 Answers  


What is facttable granularity?

2 Answers  


where does the default group roew in a router is stored what is the default size of memory in router

1 Answers  


followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200

2 Answers   Oracle,


What are the types of lookup caches?

10 Answers   Accenture, IBM, Informatica,


Where can we find the throughput option in informatica?

0 Answers  


Categories