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
How do you load only null records into target?
What is a joiner transformation and why it is an active one?
Describe data concatenation?
Enlist the tasks for which source qualifier transformation is used.
What is the use of code page?
What if the source is a flat-file?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
what is index?how it can work in informatica
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Explain how to import oracle sequence into informatica?
What are roles and groups and benefits of using them?
where to store informatica rejected data? How to extract the informatica rejected data?
What is a rank transform?
What is data caches/ index caches?
What is the commit type if you have a transaction control transformation in the mapping?