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.
Search found 189 matches
- Fri Jun 21, 2013 8:16 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: use of peak stage
- Replies: 3
- Views: 3020
- Tue Aug 21, 2012 10:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: OR logic
- Replies: 9
- Views: 5243
Re: OR Logic
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...
- Tue Aug 21, 2012 9:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: OR logic
- Replies: 9
- Views: 5243
OR logic
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.
There is chance to get Null data and '' data from source so that is the reason I am checking both.
- Tue Aug 21, 2012 9:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: OR logic
- Replies: 9
- Views: 5243
OR Logic
Thnaks for your reply.
My question is does the OR statement works in " if else statement"?
My question is does the OR statement works in " if else statement"?
- Tue Aug 21, 2012 8:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: OR logic
- Replies: 9
- Views: 5243
OR logic
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...
- Tue Jun 19, 2012 11:04 am
- Forum: General
- Topic: how to keep email id's as BCC using datastage
- Replies: 4
- Views: 4485
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...
- Tue Jun 19, 2012 10:55 am
- Forum: General
- Topic: how to keep email id's as BCC using datastage
- Replies: 4
- Views: 4485
- Tue Jun 19, 2012 10:05 am
- Forum: General
- Topic: how to keep email id's as BCC using datastage
- Replies: 4
- Views: 4485
how to keep email id's as BCC using datastage
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..
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..
- Tue Jun 19, 2012 8:55 am
- Forum: General
- Topic: email notifications logic
- Replies: 3
- Views: 2754
email notifications logic
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...
- Tue Jun 12, 2012 8:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Combination of Files
- Replies: 5
- Views: 2978
- Mon May 14, 2012 2:11 pm
- Forum: General
- Topic: unix crontab issue
- Replies: 0
- Views: 1821
unix crontab issue
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 ...
- Wed May 02, 2012 1:07 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Complete Data Not getting inserted into target table
- Replies: 2
- Views: 2398
- Wed May 02, 2012 11:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Complete Data Not getting inserted into target table
- Replies: 2
- Views: 2398
Complete Data Not getting inserted into target table
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,...
- Wed Apr 25, 2012 8:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Add the date parameter in column derivation in transformer
- Replies: 3
- Views: 2902
- Wed Apr 25, 2012 8:13 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Add the date parameter in column derivation in transformer
- Replies: 3
- Views: 2902