we can use SQ transformation write the query we get ans select sun(sal

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 / talluru.sankar naidu

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

Please Help Members By Posting Answers For Below Questions

What is the Process to creating lookup transformation in informatica

1048

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2310

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1177

what is diff b/t sorter t/r and agg have the option sorter property...

2184

What are the types of schemas we have in data warehouse and what are the difference between them?

947

Explain in detail scd type 2 through mapping.

1050

Where can we find the throughput option in informatica?

1066

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

2013

What is sorter transformation?

1055

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

2201

How can informatica be used for an organization?

1222

How to load a Dimension ? and how to load a fact table?

1423

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

1218

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

2084

What is informatica etl tool?

1003