Interested to Buy Any Domain ? << Click Here >> for more details...
in aggregator transformation we want to get middle record
how to implement, source containg empno,name sal,deptno,address
- 1 Answers
- 3044 Views
- Cognizant, I also Faced
- E-Mail Answers
Answer Posted / venkat8510
Please follow the below, that would be helpful.
https://www.bullraider.com/database/informatica/scenario/101-informatica-scenario35
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to load last n records of file into target table - informatica
Explain the scenario which compels informatica server to reject files?
How many types of sessions are there in informatica.please explain them?
How to Create a folder using pmrep command?
What do you understand by term role-playing dimension?
Differentiate between router and filter transformation?
What is the different lookup cache(s)?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What are the popular informatica products?
Scheduling properties,whats the default (sequential)
What is the need of etl tools?
Explain sessions and how many types of sessions are there?
What are the types of presistent cache in look up tr.
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 is the difference between informatica 7.0 and 8.0?
