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
- 9038 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / a
select yr,acc, max(decode (mon,'jan',am)) mon1,max(decode
(mon,'feb',am)) mon1,max(decode (mon,'mar',am)) mon1 from
intr
group by yr,acc
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
How do you take back up of repository?
What is target designer and target load order?
Write the prerequisite tasks to achieve the session partition?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
explain abt ur project architecture?
Explain in detail about scd type 1 through mapping.
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Tell me about MD5 functions in informatica
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Where do we use mapping variables in informatica?
Difference between Target-based loading and constraint-based loading?
How to do unit testing in informatica?
4 yrs etl devloper roles and responsibilities?any body give solutions
What is a filter transformation and why it is an active one?
