Mapping Load: The mapping prefix is used on a load or select statement to create a mapping table, these tables are different from other tables. They will be stored in separate area of memory and used as mapping tables during script execution. After execution they will automatically drop.
Ex. Mapping (Load Statement/Select Statement)
Apply Map: used for mapping data from one source to another at load time.
Ex. Applymap(‘Mapname’, expr,[default expr])
Ex. Mapping (Load Statement/Select Statement)
Apply Map: used for mapping data from one source to another at load time.
Ex. Applymap(‘Mapname’, expr,[default expr])
No comments:
Post a Comment