DB2 connector> transformer > sequential file
Data will be exported into a csv format in a sequential file.
This file will be send in a email using a sequence job.
Problem here is, how to avoid sending a blank csv file?
When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
No Answer is Posted For this Question
Be the First to Post Answer
how to closeing records after 10,000 records come?
What is the difference between Link collector and Funnel Stages?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
How to use Environment variable's in datastage?(use of process)
I have 5 different sources i want same records in 5 different targets Can you any body send me this question answer rathdsetl@gmail.com
Different ways a project can be moved to production ?...example ….export-import and Version control.
i have source like deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like target1 deptno,sal 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformerstage
insequential file 2header avaliable,and 100 records avaliable.how to skip the 2 headers and load 100 records target?
how can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction
how many dimentions and fact tables used in your project and what are names of it?
Difference between data warehousing and olap?
I have 2 Files like fileA fileB Output1 Output2 Output3 1 6 1 6 11 2 7 2 7 12 3 8 3 8 13 4 9 4 9 14 5 10 5 10 15 6 11 7 12 8 13 9 14 10 15 please let know