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
- 7057 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 |
we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd & 5th record in same target.
Is informatica power center designer has 64 bit support?
How can we delete duplicate rows from flat files?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix.
Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin
complex mapping ur project u r invlve can u explain and give real time example give me ?
what is the complex transformation you used in informatica
Explain the etl program with few examples.
Can we schedule a workflow(not a session) to run after completition of another workflow? Can we make a workflow depend on completition of another one?
what are the limitation of sorter transformation?
How many ways a relational source definition can be updated and what are they?
hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.
Teradata 
