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
- 6804 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the need of etl tools?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
How do you load only null records into target?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
what is size of u r database?
What is DR strategy for Informatica project?
What if the source is a flat-file?
What is a shortcut and copy in Informatica and how two are different with each other?
Explain the use of aggregator cache file?
Enlist few areas or real-time situations where informatica is required.
Explain pmcmd command usage in informatica
How to do unit testing in informatica?
Describe an informatica powercenter?
What are connected or unconnected transformations?
