I think, we can use the source qualifier (active transformation)- query ov

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?

Question Posted / rampriya

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

Please Help Members By Posting Answers For Below Questions

How to join three sources using joiner? Explain though mapping flow.

1191

What is the difference between informatics 7x and 8x and what is latest version?

1138

How to update a particular record in target with out running whole workflow?

1630

Can we create a Integration service without a Repository service and vice versa?

1260

in reporting we add some new objects,how we get the count of the newly added objects to the report

2252

How can we create index after completion of load process?

1166

wat are deployement groups in informatica, how it will be used for developers

1776

Sequence generator, when you move from develoment to production how will you reset

2127

where to store informatica rejected data? How to extract the informatica rejected data?

1057

what is informatica metadata?

1090

Define the various join types of joiner transformation?

1042

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

2057

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1151

What is meant by lookup transformation?

1183

What is a repository manager?

1148