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
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
where to store informatica rejected data? How to extract the informatica rejected data?
how many types of dimensions are available in informatica?
have u done any performance tuning? how u ll do?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is a rank transform?
How you can differentiate between connected lookup and unconnected lookup?
What is event and what are the tasks related to it?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What is expression transformation?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What are different types of transformations available in informatica?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
my source is junk data how will u remove that junk data by using unix please any one replay me