Sign Up Login


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

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


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

Answer / ysindhureddy77@gmail.com

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 the output files that the informatica server creats during running a session?

2 Answers   CTS,

How to display null values on a target & non-null values on a target?

3 Answers  

Describe expression transformation?

0 Answers  

if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!

8 Answers   IBM,

create a mapping to retrieve the employees who are getting salary greater than average salary?

4 Answers   TCS,

There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query

7 Answers   IBM,

how to import multiple flat files in to single target where there is no common column in the flat files

2 Answers   TCS,

I have source data like this col1 col2 col3 5 3 8 6 2 9 7 1 10 and i want to get target as col1 col2 col3 5 1 8 6 2 9 7 3 10 which transformation i have to use and how?

3 Answers  

Router T/R is active but some people are saying it is also passive which is exactly right?

5 Answers  

Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..

5 Answers   iGate,

write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000

5 Answers   CTS,

I have source like this 1:2;3. so i want to load the target as 123

4 Answers   HP,

For more Informatica Interview Questions Click Here
Categories