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
How do you remove duplicate records in informatica? And how many ways are there to do it?
How to convert multiple rows to single row (multiple columns) in informatica
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Explain the code page compatibility?
What is the sequence generator transformation in informatica?
Write the unconnected lookup syntax?
What is dynamic cache?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What is dimensional table?
What do you mean by worklet?
What is expression transformation?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
How might one distinguish in the case of mapping is right or not without associating session?
Explain what are the different versions of informatica?