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
- 29182 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to go to the older version for a mapping?
What is an aggregator transformation?
How to do unit testing in informatica?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Slowly changing dimensions, types and where will you use them
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is xml source qualifier transformation in informatica?
What is joiner change?
What are active transformations.
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What is confirmed fact in dataware housing?
What is the commit type if you have a transaction control transformation in the mapping?
How do you set a varible in incremental aggregation
Whats the difference between informatica powercenter server, repositoryserver and repository?
