Search This Blog

Monday, September 13, 2010

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 ..."

Wednesday, September 8, 2010

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..."