Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 5 Answers
- 10235 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / rampriya
I think, we can use the source qualifier (active
transformation)- query override
select sum(sal) from emp where dept=10
| Is This Answer Correct ? | 10 Yes | 3 No |
Post New Answer View All Answers
Slowly changing dimensions, types and where will you use them
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
complex mapping ur project u r invlve can u explain and give real time example give me ?
what is the size of u r source(like file or table)?
What is an expression transformation?
What all join we can perform in LOOKUP transformation?
What are connected or unconnected transformations?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What are the different types of repositories created using informatica?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
what is the -ve test case in your project.
Explain what are the different versions of informatica?
Can we create multiple integration service on single repository?
4 yrs etl devloper roles and responsibilities?any body give solutions
