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

What is informatica etl tool?

1053

What are different types of transformations available in informatica?

1056

How to call shell scripts from informatica?

1042

On which transformations you created partitions in your project?

1427

How to create the source and target database connections in server manager?

1128

How to generate sequence numbers without using the sequence generator transformation?

1252

How to elaborate tracing level?

1217

What is a grid in Informatica?

1113

Which development components of informatica have the highest usage?

1094

Explain what transformation and how many are there in informatica?

1021

What does refresh system mean, and what are its distinctive choice?

1266

What is the way to execute pl/sql script using informatica mapping?

1677

r u done any partitions in ur project?

1862

What is the difference between stop and abort in informatica

1140

How do you load only null records into target? Explain through mapping flow.

2070