If we are using an aggregator but forget to mention the
group by port .what will be the output??
Answer Posted / g. manthiramoorthy
If we miss to enable any of the port as GROUP BY,
the aggregator will write the last row of the table to the
next transformation
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What are the prerequisite tasks to achieve the session partition?
Explain the difference between mapping parameter and mapping variable?
How to generate sequence numbers?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What is difference between a gateway node and worker node?
How to load last n records of file into target table - informatica
Define enterprise data warehousing?
What is an aggregator transformation?
design of staging area?
How to convert multiple rows to single row (multiple columns) in informatica
What is the difference between stop and abort in informatica
What do you mean by filter transformation?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
can we override a native sql query within informatica? Where do we do it? How do we do it?