Source -> SQ -> Agg T/F to get sum (group by id) -> Joiner (to joi

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

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

Please Help Members By Posting Answers For Below Questions

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

950

what are the deliverables?in your project?

2084

Write the prerequisite tasks to achieve the session partition?

1072

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9736

Why is sorter an active transformation?

1058

expain about the tune parameters?

2338

What is a router transformation?

1047

What are the popular informatica products?

958

How to convert multiple rows to single row (multiple columns) in informatica

1317

What is the cumulative sum and moving sum?

1136

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?

1107

tell me 5 session failure in real time how can you solve that in your project?

2184

Describe expression transformation?

1044

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2021

Define pmcmd command?

993