Interested to Buy Any Domain ? << Click Here >> for more details...
I have source like this
year account month amount
----- --------- ------ --------
1999 salaries jan 9600
1999 salaries feb 2000
1999 salaries mar 2500
2001 benfits jan 3000
2001 benfits feb 3500
2001 benfits mar 4000
-->i need target like this
year account month1 month2 month3
----- --------- -------- -------- --------
1999 salaries 9600 2000 2500
2001 benfits 3000 3500 4000
- 4 Answers
- 8734 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / soumen
Use following method --
sq_source --> exp_tans --> agg_trans --> target
exp_trans --> add 3 variable --
v_month1 == iif(month='jan', amount, 0)
v_month2 == iif(month='feb', amount, 0)
v_month3 == iif(month='mar', amount, 0)
agg_trans --> add 5 cols from exp_trans --
year(check group by), account(check group by), v_month1,
v_month2, v_month2
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the format of informatica objects in a repository?
What is informatica?
How to create or import flat file definition in to the warehouse designer?
What is the commit type if you have a transaction control transformation in the mapping?
What is the function of look up transformation?
What is event and what are the tasks related to it?
Which transformation should we use to normalise the COBOL and relational sources?
Suppose we do not group by on any ports of the aggregator what will be the output?
How many numbers of sessions can one group in batches?
How to partition the Session?
How to join three sources using joiner? Explain though mapping flow.
What is a sequence generator transformation?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What do you mean by filter transformation?
Scheduling properties,whats the default (sequential)
