IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL
USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT
WILL TAKE ONLY THE LAST COLUMN WHY????
Answers were Sorted based on User's Feedback
Answer / prathap
IF GROUPBY IS NOT SELECTED INFORMATICA SERVER UNDERSTANDS WHOLE TABLE AS A ONE GROUP AND ITS GIVE LAST RECORD OUT
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / amedela chandra sekhar
Aggregator t/r perform calculations from first record to
last record.There is no group it will take last record
if u are not selected groupby the integration service returns
last record from all input rows.
| Is This Answer Correct ? | 4 Yes | 5 No |
Answer / amedela chandra sekhar
when u want to perform calculations on groups u can go for
aggregator t/r.aggregate functions like
min,max,last,first,count ...
if u are not selected groupby the integration service returns
last record from all input rows.
why means that integration service rule.
| Is This Answer Correct ? | 3 Yes | 7 No |
What are the tuning techniques you applied during your last project
What is Cognos script editor?
ename,deptcount vamshi,3 kumar,5 krish,8 in o/p i want vamshi record 3 times kumar record 5 times like wise what is the logic.? give the entire logic plz
what is inline view?
What are the transformations that are not supported in mapplet?
If you done any modifications for a table in back end does it reflect in informatca warehouse or maping?
what is shared lookup&persistent lookup?
4 Answers Accenture, Cap Gemini,
What is power center repository?
Define the various join types of joiner transformation?
Normalizer transformation is not involved in Mapplet.. why???
why dimenstion tables are denormalized in nature ?
Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..