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????
- 3 Answers
- 6779 Views
- IBM, I also Faced
- E-Mail Answers
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 IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?
how many types of dimensions are available in informatica?
why sequence generator should not directly connected to joiner transformation ?
What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
what is the diff b/w union and joiner and lookup?
How to do Integration testing in Informatica?
State the limitations where we cannot use joiner in the mapping pipeline?
why we use materialized view over view?
How many transformations can be used in mapplets.
Teradata 
