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
- 2 Answers
- 4688 Views
- I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
What is flashback table ? Advance thanks
pmscmd startworkflow -sv
Where do we use mapping variables in informatica?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
According to his methodology what all you need before you build a datawarehouse
How to do the error handling of if ur source is flatfiles?
What is a snowflake schema?
What are some examples of informatica etl programs?
What is a passive transformation?
What do think which one is the better joiner or look up?
Why update strategy and union transformations are active? Explain with examples.
Why union transformation is an active transformation?
What is a sequence generator transformation?
Enlist some properties of sessions.
