Interested to Buy Any Domain ? << Click Here >> for more details...
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.........?
- 4 Answers
- 6945 Views
- I also Faced
- E-Mail Answers
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
As union transformation gives UNION ALL output, how you will get the UNION output?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
State the differences between sql override and lookup override?
What the difference is between a database, a data warehouse and a data mart?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
How does a rank transform differ from aggregator transform functions max and min?
What are the performance considerations when working with aggregator transformation?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What is the benefit of partitioning a session?
Can we create a node as a gateway node and the same node can be assigned to a grid?
differences between service based and product based?
Write the different tools in the workflow manager?
What do you mean by filter transformation?
What are the different ways to implement parallel processing in informatica?
permutations of mapplet
