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
- 8145 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
have u done any performance tuning? how u ll do?
What is data transformation manager process?
What is the use of target designer?
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
Differences between version 7.x and 8.x.
What is the difference between router and filter?
Explain your project of banking domian.
During the running session, output files are created by informatica server. Enlist few of them.
What is meant by a domain?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
How to use pmcmd utility command?
What is union transformation?
Define enterprise data warehousing?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Explain the difference between a data warehouse and a data mart?
