How can yoU improve session performance in aggregator
transformation?
- 8 Answers
- 25213 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / srikanth
hi haritha
u r correct
For using sorted input option, the order of group by ports
in the agg and sorter transfomratoins should be same as
well as the number of ports also same.
we can filter out data early in the morning by using sq
trans rather than using filter before agg hence reducing
unwanted data in teh mapping.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
How to go to the older version for a mapping?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What is standalone command task?
What is informatica worklet?
Define joiner transformation?
Can we create multiple integration service on single repository?
tell me about your project functionality
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Why do we need informatica?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
State the limitations where we cannot use joiner in the mapping pipeline?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
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
Make a note of the quantity vaults made in informatica?
