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

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

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

More Informatica Interview Questions

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

Can we create multiple integration service on single repository?

What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?

What is the sql query overwrite in source qualifier in informatica

If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.

Why filter transformation is an active one?

Please let me know how to make Data masking in informatica..

What is the benefit of partitioning a session?

What are different types of transformations available in informatica?

What is use of batch file in informatica? How many types of batch file in informatica?

1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach

can we send mail when ever it get success or faulure to other mailid?(Not company mail id)

For more Informatica Interview Questions Click Here