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
- 7632 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
What are the types of presistent cache in look up tr.
How to extract sap data using informatica?
what is mean by complex business rule ?
Tell me about MD5 functions in informatica
What are the different options available for update strategy?
What are the types of schemas we have in data warehouse.
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Explain why we use partitioning the session in informatica?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Where do we use mapping variables in informatica?
What is the command used to run a batch?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
