In a simple mapping when i use aggregate t/r with out any
condition or group by, i am getting output as only last
record in the table . can any one explain it please.........?
Answer Posted / ankit kansal
By Default informtica finds a group on the basis of your group by check boxes and returns you last row of each group when you don't specify any group by clause then it takes whole data set as a single group and returns you the last row of that whole group...
please make me correct if i am wrong..
http://deepinopensource.blogspot.in
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How do you handle two sessions in Informatica
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What are the new features of informatica 9.x developer?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What are the restrictions of union transformation?
How many input parameters can exist in an unconnected lookup?
What is DR strategy for Informatica project?
What is a pre-defined event and user-defined event?
How to create Target definition for flat files?
Explain the different dimensions.
What is a router transformation?
How many ways are there to do 'remove duplicate records in informatica'?
What are the databases that informatica can connect to windows?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Enlist the differences between database and data warehouse.