What is the expected value if the column in an aggregator transform is neither a

What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?

Question Posted / amit vikram

1 Answers
1560 Views
I also Faced
E-Mail Answers

What is the expected value if the column in an aggregator transform is neither a group by nor an agg..

If we do not use an input port in group-by neither in aggregate expression, the Integration Service
will return only the last row value of the column for the input rows.
For example, if we have 100 rows coming from source then aggregator will output only the last record (100th
record)

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Informatica Interview Questions

What are variable ports and list two situations when they can be used?

1 Answers

My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?

3 Answers HP,

What is rank transformation in informatica

0 Answers Informatica,

Performance wise which is better joiner or look up ? Give me with example?

1 Answers CGI,

How to view and Generate Metadata Reports?

1 Answers

what is shared lookup&persistent lookup?

4 Answers Accenture, Cap Gemini,

What is enterprise data warehousing?

0 Answers

What is a command that used to run a batch?

4 Answers

hw to load this give the mapping? cty state o/p c1 s1 c1 c1 s2 s1 c1 s1 c1 c2 s3 s2 c3 s4 c1 c3 s2 s1 c2 s3 c3 s4 c3 s2 2 columns should be loaded to one column in target table?

1 Answers Wipro,

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.

2 Answers TCS,

How to recover the standalone session?

2 Answers

How can we get multiple output values using an unconnected lookup transformation?

2 Answers TCS,

For more Informatica Interview Questions Click Here