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

Differentiate between sessions and batches?

1001

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2220

What is informatica? Why do we need it?

1082

How will the document be delivered to me?

1062

What are the uses of etl tools?

1111

How might you approve all mappings in the archive all the while?

1004

Different sorts of metadata that stores in the storage facility?

994

How can we delete duplicate rows from flat files?

1204

How is union transformation utilized?

996

How many dimensions are there in informatica?

1066

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2285

What could be the possible resons of locks by user?

1077

As union transformation gives UNION ALL output, how you will get the UNION output?

1086

What are the components of Informatica? And what is the purpose of each?

1030

What are the components of workflow manager?

1074