How to set memory size in Hierarchical Stage

Check the datastage installation 32 bit or 64 bit

$ . ./dsenv
$ file $APT_ORCHHOME/bin/osh

Try to execute the below command to find out the maximum size of allowable heap size for the environment.

java -Xmx4096m myClass

If it can not be loaded then go to AppServer and check wsadmin

vi /home/IBM/WebSphere/AppServer/bin/wsadmin.sh

search for PLATFORM and try to find Linux PREF_JVM_OPTION and check if MaxPermSize is set or not.

Now set the heap_size in the properties of Hierarchical stage as 4096 mb which was by default 256mb

Project Level Issue

To Check what will be the NLS Map for Oracle
=====================================

select DECODE(parameter, 'NLS_CHARACTERSET', 'CHARACTER SET',
'NLS_LANGUAGE', 'LANGUAGE',
'NLS_TERRITORY', 'TERRITORY') name,
value from v$nls_parameters
WHERE parameter IN ( 'NLS_CHARACTERSET', 'NLS_LANGUAGE', 'NLS_TERRITORY');

To omit any new line from a column in SQL Server
=====================================
select ID002,ID003,ID006,ID010,ID017,ID018,ID019_PHONE,ID019_MAIL,ID019_EMAIL,ID027,ID030,ID037,ID076,ID077,ID081,ID092,ID093,ID094,ID097,REPLACE(REPLACE(ID098, CHAR(13), ''), CHAR(10), '') as ID098,REPLACE(REPLACE(ID099, CHAR(13), ''), CHAR(10), '') as ID099,REPLACE(REPLACE(ID100, CHAR(13), ''), CHAR(10), '') as ID100,ID101,ID103,ID104,ID120,ID121,ID134,ID135,ID136,ID139 from VW_CRM_CAMS_CORPORATE

select ID002,ID003,ID006,ID010,ID017,ID018,ID019_PHONE,ID019_MAIL,ID019_EMAIL,ID027,ID030,ID037,ID076,ID077,ID081,ID092,ID093,ID094,ID097,REPLACE(REPLACE(REPLACE(ID098, CHAR(13) + CHAR(10), ' '), CHAR(13), ' '), CHAR(10), ' ') as ID098,REPLACE(REPLACE(REPLACE(ID099, CHAR(13) + CHAR(10), ' '), CHAR(13), ' '), CHAR(10), ' ') as ID099,REPLACE(REPLACE(REPLACE(ID100, CHAR(13) + CHAR(10), ' '), CHAR(13), ' '), CHAR(10), ' ') as ID100,ID101,ID103,ID104,ID120,ID121,ID134,ID135,ID136,ID139 from VW_CRM_CAMS_CORPORATE