DOubt about MApping Table

[nikhilgarg]

Hey,

I have a question. Does the following true about ApplyMap () ??

1 )  No error if the mapping table does not exists. ??

2)   Mapping table exists after LOAD ??

Thanks

[Anonymous]

Hi ,

Can you post your sample data

[#3]

Hi Nikhil,

    Can you share the  error details...and Syntax for Applymap is as follows:

APPLYMAP('Mapping_Table_Name',FieldName,'Default Value') AS [Required Field]

Note: Mapping Table Name must be enclosed with single qoutes.

regards,

Ankur

[NareshGuntur]

Hey Nikhil,

Can you post the error you get?

Cheers,

Naresh

[nikhilgarg]

HEy,

Actually i again tried it and does not get any error . Rather i get a column added with null values.

So no error is there.