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

i have a source of n records.i have to load n+5 records to my target.What is the procedure??????plz tell me.....

1 Answers

Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

5 Answers HP,

What is the difference between Normal load and Bulk load?

5 Answers

what is work of PUSH DOWN option

2 Answers Wipro,

what is bitmap index? did u use it?and how to use it in informatica

1 Answers IBM,

Which means the first record should come as last record and last record should come as first record and load into the target file?

0 Answers Informatica,

What is deployemnt groups, Lables, query and dynamic deployment group.

1 Answers IBM, SVP,

Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3 then can any body please send me what is th scnario. my mail i shek.inform@gmail.com

6 Answers HCL, Schneider,

How to handle changing source file counts in a mapping?

3 Answers Deloitte, TCS,

what is normalizer transformation?

4 Answers Wipro,

Please let me know how to do estimation before staring development in project. Here estimation in the sense how many associates are required, etc to complete the project.

1 Answers iGate,

i have one senario i have table with 2columns one for primary key another is a constant value(zero). i have to lookup the table and get the maximum primary key here i don't have any common column between source and lookup table(wt table i explained above)... table is (i am assuming he didn't give the table) column1 column2 5 0 2 0 8 0 6 0 3 0 12 0 7 0

2 Answers TCS,

For more Informatica Interview Questions Click Here