in aggregator transformation we want to get middle record
how to implement, source containg empno,name sal,deptno,address
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
what is the size of your data warehousing?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
can u give example for factless fact table
What does “tail –f” command do and what is its use as an Informatica admin.
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
How to open an older version of an object in the workspace?
What is informatica?
How do you migrate data from one environment to another?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is data caches/ index caches?
Explain the shared cache and re-cache?
Can anyone tell me the new features in Informatica 9 Version?
What all join we can perform in LOOKUP transformation?
Mention few power centre client applications with their basic purpose?