BI Applications: Rows to columns and Columns to Rows in Oracle

BI Applications: Rows to columns and Columns to Rows in Oracle: "Many a times we need to display data in different ways. Multiple rows in table need to be displayed as columns and vice-verse. The below li..."

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