BI Applications: TO_CHAR(date column) returns zero

BI Applications: TO_CHAR(date column) returns zero: "In Oracle Database we face this issue sometimes. We see that Date field contains all zeros Example - select to_char(Date_column,'dd-mm-yyyy ..."

BI Applications: Unsupported conversion Error for INFA maps on Orac...

BI Applications: Unsupported conversion Error for INFA maps on Orac...: "If your ETL tasks are failing with error as Unsupported conversion Error and log mentions something like below - ORA-26097: unsupported conv..."

BI Applications: Debug the Debugger of INFA

BI Applications: Debug the Debugger of INFA: "Many times we face issues while using the debugger feature of Informatica. We get error saying 'Error connecting to DTM Service' There are..."

BI Applications: DAC - For First Timers

BI Applications: DAC - For First Timers: "DAC is the Datawarehouse Administration Console which is an important component of the OBIA stack. To understand DAC and learn all its feat..."

BI Applications: Oracle BI Applications

BI Applications: Oracle BI Applications: "I have faced this question many times. What is Oracle BI Applications. In simple words its a prebuilt BI solution which can support multip..."

Converting multiple rows into a single comma separated row

Recently, I have been bitten by the MSDN forums bug. I enjoy spending time in the SSAS and SSRS forums, and the learning that I take out from there is tremendous. Initially, I just used to read and learn, while now I reply to a lot of posts too (just the simple ones, keep the tough ones for the experts to solve ;) ).

So the other day, there was this post - how can you convert multiple rows into a single comma separated row? For eg,

This can be done by the FOR XML command.

select State, (
select City + ',' as [text()]
from tableA soi
where soi.State=t.State
order by City
for xml path( '' )
)
from tableA s )t

A handy command, especially because you don't have to use stored procedures to achieve the result.

Stagnation

Well it's been quite a while since I posted anything here and quite frankly it's been quite a while since I found anything worth posting. My work occupies most of my time and it seems like I have lost that zeal to learn and try out new stuff. So,as part of this year's resolution, I have decided to hit the books again! Hopefully you will see a new post coming from me soon.

Meanwhile, I just thought of sharing this link with all of you. I hit this link during my inital training days and have found this quite useful.

http://learndatamodeling.com/

Regards,
Chandan
'Knowledge should not be speculative, it should be certainty'