how to avaoid Junk values in Fast Export

Tools

how to avaoid Junk values in Fast Export

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
8 REPLIES

Re: how to avaoid Junk values in Fast Export

giving correct datatype and size of each column.v can avoid the junk values
SN
N/A

Re: how to avaoid Junk values in Fast Export

hi,

you cannot load data into tables using fast xport. I assume it was a typo... did you mean fastload?

reg,

Re: how to avaoid Junk values in Fast Export

sorry..., Loading the data into Fast load only....

Re: how to avaoid Junk values in Fast Export

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.

Re: how to avaoid Junk values in Fast Export

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
;

Re: how to avaoid Junk values in Fast Export

Thanks

Re: how to avaoid Junk values in Fast Export

Guys i need your help..

When i am fast exporting byte format data in UNIX, it is giving me special character.

Tell me how to export byte format data properly

Teradata Employee

Re: how to avaoid Junk values in Fast Export

What do you mean "byte format"?

Is the "special" character the first character of the data?

If so, that is probably the row length.

-- SteveF