DSXchange

Hi ,
Can someone help me for below requirement .

I am getting data in below format from source


col1,col2,col3, col4

1, 100 , , xyz
1, 100, abc,

the expected output should be

col1,col2,col3, col4
1, 100 , abc , xyz

i know we can accomplish using the peak stage but not sure how to do it.

shall i need to keep the OR Statement in (), like below or does not matter? 1>if ( isnull(lkp_op.VENDOR_LID) OR lkp_op.VENDOR_LID='' ) then NullToEmpty(lkp_op.VENDOR_LID) else lkp_op.VENDOR_LID 2>if isnull(lkp_op.VENDOR_LID) OR lkp_op.VENDOR_LID='' then NullToEmpty(lkp_op.VENDOR_LID) else lkp_op.VEN...

Why i kept two statements is

There is chance to get Null data and '' data from source so that is the reason I am checking both.

Thnaks for your reply.

My question is does the OR statement works in " if else statement"?

Hi , i am have basic question. Does the below 2 logic work in the same way in datastage? i am having issue with number 1 1>if isnull(lkp_op.VENDOR_LID) OR lkp_op.VENDOR_LID='' then NullToEmpty(lkp_op.VENDOR_LID) else lkp_op.VENDOR_LID 2>if isnull(lkp_op.VENDOR_LID) then NullToEmpty(lkp_op.VENDOR_LID...

I checked DSSendMail Routine, I am not seeing any flixibilty to add BCC option and also adding dynamic message body.. can some one help me to custamize the below routine. $INCLUDE DSINCLUDE JOBCONTROL.H * This is just an interlude to the DSSendMail job control function, * to allow it to be called as...

Thanks chulett.

Can you also tell me how to send dynamic TEXT content in the email body?

hi ,

i want to send bulk email's using datastage but all the email id's should go as in BCC, other people should not see the email id's .

Can you help me..

hi , I need some help regarding sending email notification using datastage In source file, i am getting data as below.. Email_ID|EMAIL_SUBJECT|EMAIL_content abc@gmail.com|Text for email1|test1 efg@yahoo.com|Text for email2|test2 rrr@yahoo.com|Text for email3|test3 ttt@gmail.com|Text for email4|test4...

i selected file Name Column but what we need to mention in the File name column? can you please tell us

hi , using vi editor i did changes to the crontab using the command: crontab -e and saved the changes using the cmd: wq, i am using the bash unix shell after saving,i am getting msg "/tmp/crontabb7aO_E" 36 lines, 8737 characters" but when i checked the same crontab after 2 days, i am ...

Any inputs to the above issue will be appreciated

Hi, I have one job which reads data from Oracle table and loads into Oracle Table but into different schema, the job ran fine and there are no warning's in the director and counts in the job are showing as expected but complete data is not loaded into Oracle target table. ex: in the job target link,...

small correction...

'01_':TODAYS_DATE

try this..

'01':TODAYS_DATE