In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal.
Is there any othere transformation than the aggrator? if
yes how?
Answer Posted / talluru.sankar naidu
we can use SQ transformation write the query we get ans
select sun(sal) from emp where deptno=10 and deptno=5;
I think its correct
Is This Answer Correct ? | 1 Yes | 8 No |
Post New Answer View All Answers
What is parallel processing in informatica?
Define mapping and session?
What is resilience time?
What is intricate mapping?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What does update strategy mean, and what are the different option of it?
What the difference is between a database, a data warehouse and a data mart?
explain about unit testing? in real time?
How big was your fact table
what are factless facts? And in which scenario will you use such kinds of fact tables.
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 the function of look up transformation?
How to elaborate tracing level?
What are the different versions of informatica?
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?