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
- 6951 Views
- I also Faced
- E-Mail Answers
Answer Posted / srinivas.medagum
When the records come from SQ each record from first one
checks for the group by port but till last record it doesnot
found .So by default as the last record considered as only
record it stores in Agg T/R.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How to create a non-reusable instance of reusable transformations?
can we override a native sql query within informatica? How do we do it?
What is option by which we can run all the sessions in a batch simultaneously?
Explain the difference between mapping parameter and mapping variable?
update strategy transformation in informatica
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
State the differences between sql override and lookup override?
expain about the tune parameters?
Parameter and variable differences
Explain what are the different types of transformation available in informatica.
Briefly describe lookup transformation?
What is the maplet?
Why union transformation is an active transformation?
Differentiate between a repository server and a powerhouse?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
