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
- 29362 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
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Different sorts of metadata that stores in the storage facility?
Enlist some properties of sessions.
How many types of sessions are there in informatica.please explain them?
What is an active transformation?
What happens when a session fails and you click on recover?
What is rank transform?
What is an expression transformation in informatica?
Separate from a database, an information bazaar, and an information stockroom?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
can u give example for factless fact table
During the running session, output files are created by informatica server. Enlist few of them.
Can anyone tell me the new features in Informatica 9 Version?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
How to join three sources using joiner?
