|
|
|
Junior Member
 
Group: Forum Members
Last Login: 9/8/2008 7:42:33 AM
Posts: 22,
Visits: 53
|
|
Hi ,
Can anyone tel me , how to avoid the Junk values while loading the data into tables using Fast Export.
Regards,
Maran A
Oracle Certified + DW BI Proffessional
Best Regards,
Maran A
Oracle Certified & DW+BI Proffessional
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 9/17/2008 6:21:35 AM
Posts: 30,
Visits: 105
|
|
giving correct datatype and size of each column.v can avoid the junk values
SHEEBA
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 11/23/2008 11:25:35 PM
Posts: 76,
Visits: 148
|
|
hi,
you cannot load data into tables using fast xport. I assume it was a typo... did you mean fastload?
reg,
-SN
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 9/8/2008 7:42:33 AM
Posts: 22,
Visits: 53
|
|
sorry..., Loading the data into Fast load only....
Best Regards,
Maran A
Oracle Certified & DW+BI Proffessional
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 9/8/2008 7:42:33 AM
Posts: 22,
Visits: 53
|
|
Hey Sheeba,
Thnx for your reply . But I am not convinienced..,
Let me give you an Example, Junk value can be any special character ( | , @ , $, ~ ) , I want to remove this beofore populating into the target table , But i dont know , what could be the Jun value..? we need find out this in Run time... is it Possible???
thanks in Advance.. Waiting for your response.
Best Regards,
Maran A
Oracle Certified & DW+BI Proffessional
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 9/17/2008 6:21:35 AM
Posts: 30,
Visits: 105
|
|
this is the example
SELECT CAST(a_MODNUM_R AS CHAR(11)) (title '')
,CAST(a_VERNUM_R AS CHAR(11)) (title '')
,a_MODEL_TP_C (CHAR(1)) (title '')
,a_SCRTYP_C (CHAR(1)) (title '')
,a_SCRTYP_X (CHAR(10)) (title '')
,a_MDLDESC_X (CHAR(100)) (title '')
,a_VERDESC_X (CHAR(100)) (title '')
,a_VEREFF_Y (FORMAT 'YYYY-MM-DD') (CHAR(10)) (title '')
,(CASE
WHEN a_VEREND_Y IS NULL
THEN CAST('9999-12-31' AS CHAR(10) )
ELSE CAST(CAST(a_VEREND_Y AS FORMAT 'YYYY-MM-DD')
AS CHAR(10))
END) (title '')
,a_MOD_CATEG_C (CHAR(2)) (title '')
,(a_MOD_CATEG_X||' ') (char(15)) (title '')
FROM a_MODEL_TBL
ORDER BY 1,2
;
SHEEBA
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 9/8/2008 7:42:33 AM
Posts: 22,
Visits: 53
|
|
Thanks
Best Regards,
Maran A
Oracle Certified & DW+BI Proffessional
|
|
|
|