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

Explian the Process of deployment groups in informatica

1065

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8206

Do you find any difficulty while working with flat files as source and target?

1106

What do you mean by channel change?

1055

Can we get 1st record through Informatica(without sequence number).

1488

How to go to the older version for a mapping?

1109

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

9835

In which transformation you cannot drag ports into it?

1326

my source is junk data how will u remove that junk data by using unix please any one replay me

3708

What are connected or unconnected transformations?

1128

What are the main features of Oracle 8i with context to datawarehouse?

2115

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

2239

What are the transformations that are not supported in mapplet?

1039

Define pmcmd command?

1049

What is a mapplet/worklet in informatica?

1193