Interested to Buy Any Domain ? << Click Here >> for more details...
IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL
USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT
WILL TAKE ONLY THE LAST COLUMN WHY????
- 3 Answers
- 7856 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / amedela chandra sekhar
Aggregator t/r perform calculations from first record to
last record.There is no group it will take last record
if u are not selected groupby the integration service returns
last record from all input rows.
| Is This Answer Correct ? | 4 Yes | 5 No |
Post New Answer View All Answers
How to create the source and target database connections in server manager?
What does “tail –f” command do and what is its use as an Informatica admin.
Explain target update override in informatica
What is the need of an ETL tool?
How does the aggregator transformation handle null values?
What are the mapping parameters and mapping variables?
How can one identify whether mapping is correct or not without connecting session?
what is diff b/t sorter t/r and agg have the option sorter property...
Write the unconnected lookup syntax and how to return more than one column.
What is domain and gateway node?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What are the designer tools for creating transformations?
Differentiate between Load Manager and DTM?
What is rank index in rank transformation?
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
