Interested to Buy Any Domain ? << Click Here >> for more details...
if we hav 10 records in a file, can we get first record from
it by using Aggregator with out using Groupby Port in it?If
Yes..let me know the answer plz!!!
- 8 Answers
- 29500 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / jhilam roy
Sorry guys...correction...If you do not select any group by
port in an Aggregator transformation and also want the first
record of any input record set, then, simply use the FIRST
function with no group by ports selected. Because, if there
is no group by ports selected, by default, FIRST treats all
rows as one group, returning one value. However, make sure
that the first record is not NULL. If a value is NULL, FIRST
ignores the row.
| Is This Answer Correct ? | 26 Yes | 2 No |
Answer / jayesh
Dont use group by.By default it will give last row.To
override it,use FIRST function.
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / jhilam roy
Simple answer: NO, provided, only the Aggregator
transformation is used.
In an Aggregator transformation, if no port is selected as
Group By, then by default, the PowerCenter Sever returns the
very last row of the input record set, definitely not the
first one.
It scans sequentially starting from the first port of the
input set and continues till the last port is hit. If it
fails to find any port designated as Group By, the default
nature is to return the last record of the input record set
to the downstream transformation or target.
Any updation is appreciated.
Jhilam
| Is This Answer Correct ? | 7 Yes | 5 No |
Answer / naresh
I have column like col1,col2,col3 i am using first function
in col2 it work only that col2 i want first record means
col1,col2,col3 all first values How to get Please give me
solution.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / janardhan
Hi Guys, I need sql query for the above functionality.
I mean sql query to get last record from 10 records same like aggregator transformation in informatica which gives last record if we don't give any group by.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / bala
@abhinav...
How can you sort records by using rownum...its not possible
| Is This Answer Correct ? | 1 Yes | 2 No |
Yes, we can get first record using aggregator below are the
steps:
First need to sort all the records by desc and connect to
aggregator transformation than connect to target without
using gropby port than you will get first record.
Ask me any questions to <ittoolboxdwh@gmail.com> this is my
mailid.
Cheers
Venkat.
| Is This Answer Correct ? | 6 Yes | 9 No |
Answer / abhinav
hey I am having one answer regarding the same.may be it
will work.
SQ (sql override)(select * from emp1 order by rownum desc)--
>aggregator-->target
thanks
Abhinav
| Is This Answer Correct ? | 1 Yes | 6 No |
what are the reusable tasks in informatica ?
11 Answers CTS, HP, IBM, TCS,
What is the meaning of decode in informatica?
What are the different versions of informatica?
What is the command used to run a batch?
Clarify the utilization of aggregator cache record?
what type of documents you receiving from client later wt can you do? what type of documents have to prepare?
what is a junk dimension ?
14 Answers Atos Origin, Cognizant, HS, NIIT, TCS,
Hello...... How can i set my mapping as read-only? Please answer me. Advance thanks
In which conditions we can not use joiner transformation (Limitaions of joiner transformation) ?
What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall? Please answer below. thank you.
I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?
What is data merging, data cleansing and sampling?
Teradata 
