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
- 29219 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
What is meant by a domain?
where to store informatica rejected data?
Suppose we do not group by on any ports of the aggregator what will be the output?
Enlist the various types of transformations.
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is an Integration service in Informatica?
Could you explain what is enterprise data warehouse?
Can we override a native sql query within informatica?
Tell me about Propagate functions in informatica
What are the different types of olap? Give an example?
How can you generate reports in informatica?
Explain direct and indirect flat file loading (source file type) - informatica
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
How to go to the older version for a mapping?
