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
- 29075 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 might one distinguish in the case of mapping is right or not without associating session?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
How to differentiate between the active and passive transformations?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
explain one complex mapping with logic? sales project?
Which is the t/r that builts only single cache memory?
is it possible to index the data in cache of lkp transformation ?
Do you find any difficulty while working with flat files as source and target?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What is persistent lookup cache?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
How do you migrate data from one environment to another?
Explain sessions?
Briefly define a session task?
How do you manage the Parameter files while migrating your data from one environment to another environment?
