hi,there is a scenario like.
there are three columns empid,salmonth, sal contains the values 101,jan,1000
101 feb 1000 like twelve rows are there then my required out put is like
contains 13 columns empid jan feb marc.......dec and the velues are
101 1000 1000 1000 like this . thank you
Answer Posted / veeru
Use DECODE FUNCTION you can get answer.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain in detail scd type 2 through mapping.
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 all join we can perform in LOOKUP transformation?
What is an unconnected transformation?
What are the conditions needed to improve the performance of informatica aggregator transformation?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Why do we need informatica?
What is the scenario which compels informatica server to reject files?
What is confirmed fact in dataware housing?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
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
tell me 5 session failure in real time how can you solve that in your project?
Implementation methodology
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?