wat transf shud i use to achieve this id sal id sal sum src-1 20

wat transf shud i use to achieve this

id sal id sal sum
src-1 20 tgt 1 20 40
1 20 1 20 40
2 15 2 15 35
2 20 2 20 35

Question Posted / guest

2 Answers
5361 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 ..

Answer / uma

Source -> SQ -> Agg T/F to get sum (group by id) -> Joiner (to join SQ and output of aggr transformation) -> Target

Is This Answer Correct ?

7 Yes

1 No

wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 ..

Answer / rk

Use analytical function if source is database..
SELECT ID, SAL, SUM(SAL) OVER (PARTITION BY ID) AS SUM from table.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Informatica Interview Questions

What is a configuration management?

1 Answers

What is the diff. b/w informatica versions 8.1.1 and 8.6.1?

4 Answers IBM, Wipro,

How many types of sessions are there in informatica.please explain them?

0 Answers Informatica,

What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?

1 Answers

Explain pushdown optimization $pushdownconfig parameter - informatica

0 Answers Informatica,

Hi experts, > I 'm having data like this and it's in flat file. > sno,name,marks,result > 1, ak, 80,p > 2, , ,20,f > 3,jack,55,p > > now in the second row a comma(,) is placed instead of name(char). > > when importing into SQ , in flat file wizard the num of columns increased to 5 instead of 4. > > could you tell me how to over come this issue.........

1 Answers TCS,

in aggregator transformation we want to get middle record how to implement, source containg empno,name sal,deptno,address

1 Answers Cognizant,

split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar

1 Answers Cap Gemini, TCS, Wipro,

What is the reusable transformation?

0 Answers

i have 5 session (s1,s,2,s3,s4,s5)i want to execute first 4 session after 5th session how will you do?

8 Answers iNautix,

hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.

10 Answers

What is meant by active and passive transformation?

0 Answers

For more Informatica Interview Questions Click Here