Error while loading data

[#1]

Actually i have sql developer database in that i am trying to give '|' Pipe symbol for concatenation , but its not working here am sharing the QVW fie go through with that file and guide me .

[ashfaq_haseeb]

Hi,

Try below

OLEDB CONNECT TO [Provider=MSDAORA.1;User ID=hr;Data Source=orcl] (XPassword is JWFZHUJOVF);

Jobs:

Load *;

SQL SELECT "JOB_ID",

    "JOB_TITLE",

    "MAX_SALARY",

    "MIN_SALARY"

FROM HR.JOBS;

JHS:

Load *,

"DEPARTMENT_ID" & "EMPLOYEE_ID" & "JOB_ID" as key1

;

SQL SELECT //cast("DEPARTMENT_ID" as char) ||  cast("EMPLOYEE_ID" as char) || cast("JOB_ID" as char) as key1 ,

  "DEPARTMENT_ID"

    "EMPLOYEE_ID",

    "END_DATE",

    "JOB_ID",

    "START_DATE"

FROM HR."JOB_HISTORY";

Load *,

"DEPARTMENT_ID" & "EMPLOYEE_ID" & "JOB_ID" as key1

;

EMP:

SQL SELECT

  "COMMISSION_PCT",

    "DEPARTMENT_ID",

    "DEPARTMENT_ID" as d_id,

    EMAIL,

    "EMPLOYEE_ID",

    "FIRST_NAME",

    "HIRE_DATE",

    "JOB_ID",

    "LAST_NAME",

    "MANAGER_ID",

    "PHONE_NUMBER",

    SALARY

FROM HR.EMPLOYEES;

Dept:

Load *

;

SQL SELECT "DEPARTMENT_ID" as d_id,

    "DEPARTMENT_NAME",

    "LOCATION_ID",

    "MANAGER_ID" as m_id

FROM HR.DEPARTMENTS;

Regards

ASHFAQ

[maxgro]

if you want to concatenate strings, in Oracle

use ||

not |

so this works, change your sql in same way

OLEDB CONNECT32 TO [Provider=MSDAORA.1;User ID=dwh_staging;Data Source=dwcci1] (XPassword is xxxxxxxxxxxxxxxxxxx);

a:

load *;

SQL SELECT

"TIP_ANNO" || "TIP_MESE",

    "TIP_GIORNO",

    "TIP_GIORNO_ANNO"

FROM "DWH_XXX"."D000_CALENDARIO_CCI";