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 / arun kumar
Hey Friend,
First try to understand the query first.Here we need to calculate the sum salary of 5 members from deptno 10 with using Aggregation Transformation in informatica.
Yes, we can calculate group of records with our using aggregator by taking 2 sorter transformation and 2 expression transformations and 1 filter transformation.
I have done this with using 5 transformations and it worked.
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is informatica worklet?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
what are factless facts? And in which scenario will you use such kinds of fact tables.
is it possible to index the data in cache of lkp transformation ?
What does role playing dimension mean?
How does a rank transform differ from aggregator transform functions max and min?
What are the data movement modes in informatica?
Explain the types of transformations?
How to load the data from a flat file into the target where the source flat file name changes daily?
In how many ways we can create ports?
How many numbers of sessions can one group in batches?
Whats the difference between informatica powercenter server, repositoryserver and repository?
what is informatica metadata?
What is sequence generator transformation in informatica?
Explain the different dimensions.