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
- 29468 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 SDLC way of code development?
What do you understand by term role-playing dimension?
What is the Process to creating lookup transformation in informatica
What are the components of Informatica? And what is the purpose of each?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What are the types of caches in lookup? Explain them.
How do you use reject loader.
How you can differentiate between connected lookup and unconnected lookup?
What are roles and groups and benefits of using them?
What is the difference between router and filter?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What are the uses of etl tools?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What is an aggregator transformation?
