Answer / rampriya

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

select sum(sal) from emp where dept=10

Answer / sahil

We can use a query,

Select dep_id, sum(salary) from emp group by dep_id;

Here I am using group by because we might have other dep as well.

Answer / 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.

Answer / eswar

No, In Informatica, you dont have any other transformation
than Aggregator. Aggregator is used for calculatins such as
Avg, Sum which are performed on groups.

Answer / 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

how to read data from website into informatica? plsss send answers ASAP thanks in advance.

1 Answers   DELL,

Is informatica power center designer has 64 bit support?

1 Answers  

What is an expression transformation in informatica?

0 Answers  

what is pre and post sql and what is diff between source presql and target pre sql

1 Answers   HCL, IBM,

what are the challenge face in u r project?explain me

1 Answers   iGate, TCS,

what is surrogate id ?

3 Answers   IBM,

what is the Default Source Option For Update Strategy Transformation?

0 Answers   Informatica,

In my sourse i have like ename,gender vasu,male geetha,female ram,male suma.female kesav,male in my output i need male,female vasu,geetha ram,suma kesav

5 Answers  

hi all when i am creating repository contents i am getting this error and not able to create contents please let me know wht may be the problem ORA-01031: insufficient privileges Database driver error... Function Name : executeDirect SQL Stmt : CREATE VIEW REP_DATABASE_DEFS AS SELECT DISTINCT DBDNAM DATABASE_NAME, SRCNAM DEF_SOURCE, SUBJ_NAME SUBJECT_AREA, NULL VERSION_ID, OPB_DBD.VERSION_NUMBER DATABASE_VERSION_NUMBER FROM OPB_DBD, OPB_SUBJECT, OPB_SRC WHERE OPB_DBD.SUBJ_ID = OPB_SUBJECT.SUBJ_ID AND OPB_SRC.DBDID = OPB_DBD.DBDID AND OPB_SRC.VERSION_NUMBER = OPB_DBD.VERSION_NUMBER AND OPB_SRC.IS_VISIBLE = 1 Oracle Fatal Error Database driver error... Function Name : ExecuteDirect Oracle Fatal Error Error occurred while creating the repository An error has occurred while creating contents. Dropping repository tables... Create Contents operation on repository [reposerv] ended at 01/02/2009 13:02:48. Elapsed time is 0:00:09.

2 Answers  

i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica

2 Answers   HP,

what is the logic will you implement to load data into a fact table from n dimension tables?

4 Answers   TCS,

Can we make worklet inside worklet?

1 Answers