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
- 8696 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
what is degenerated dimension?
What is an aggregator transformation?
Whats the difference between informatica powercenter server, repositoryserver and repository?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
update strategy transformation in informatica
how tokens will generate?
What is meant by lookup transformation? Explain the types of lookup transformation?
What are multi-group transformations?
Write the unconnected lookup syntax and how to return more than one column.
What is mapplet in informatica?
What is lookup transformation?
What's the layout of parameter file (what does a parameter file contain?)?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What are the transformations that are not supported in mapplet?
How is union transformation utilized?
