Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi Experts,
i want to filter out data while loading. i want to apply condition like
TIME_DATE >= TO_DATE('2010/08/15 00:00:00', 'YYYY/MM/DD HH24:MI:SS')
and
TIME_HR_DIM. TIME_DATE < TO_DATE('2011/1/25 00:00:00', 'YYYY/MM/DD HH24:MI:SS')
the upper one is a sql querry.
TIME_HR_DIM:
LOAD
"TIME_DATE"
,
"TIME_HOUR"
,
"DAY_OF_MONTH"
,
"WEEK_OF_YEAR"
,
"WEEK_STARTING_DATE"
,
"MONTH_OF_YEAR"
,
"MONTH_NAME"
,
QUARTER
,
"YEAR_OF_YEAR"
,
"HALF_YEAR"
,
"DAY_DATE"
,
"ISO_YEAR"
;
SQL
SELECT *FROM "DW_OWNER"."TIME_HR_DIM";
THANKS
SUSHIL
"TIME_ID",hi your problem will solve, if u use Where clause.
Table_Name:
LOAD
"TIME_DATE",TIME_HOUR",DAY_OF_MONTH","WEEK_OF_YEAR","WEEK_STARTING_DATE","MONTH_OF_YEAR","MONTH_NAME",QUARTER,
"YEAR_OF_YEAR","HALF_YEAR",DAY_DATE","ISO_YEAR"SQL
SELECT *
FROM "DW_OWNER"."TIME_HR_DIM"
Where
TIME_DATE >= TO_DATE('2010/08/15 00:00:00', 'YYYY/MM/DD HH24:MI:SS')
and
TIME_HR_DIM. TIME_DATE < TO_DATE('2011/1/25 00:00:00', 'YYYY/MM/DD HH24:MI:SS');
try like this..
regards
A'run'
Hi,
We can use where clause to filter the data when we are loading through SQL database tables.
What if we are loading from the excel files kept on sharepoint website, i think Where clause doesn't work for this
Any suggestions are most welcomed
Regards,
KC