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

Post New Answer

More Data Stage Interview Questions

what is operator combinality in datastage?

1 Answers   TCS,


What is a ds designer?

0 Answers  


How to perform incremental load in datastage?

0 Answers  


I have file with empid,empname and I want to load these two fields along with sal in my target 1)salary must be same for all the records 2)I want pass the salary at run time

7 Answers   TCS,


what is .dsx files

3 Answers   IBM,


CHANGE CAPTURE

0 Answers   CTS,


i have input like this Column 1 ,column 2 3,a 4,b 5.c i want output  aaa bbbb ccccc Ple help any one?

4 Answers   SLK Software,


can any one tell me how to install datastage 8.1 in windows xp with wizard

2 Answers  


To see hidden files in LINIX?

0 Answers   CTS,


in job of 30 one job is very slow due to this entire job is very slow how can u know which job is slow?

0 Answers   IBM,


Input Data is: Emp_Id, EmpInd 100, 0 100, 0 100, 0 101, 1 101, 1 102, 0 102, 0 102, 1 103, 1 103, 1 I want Output 100, 0 100, 0 100, 0 101, 1 101, 1 Means Indicator should either all ZEROs or all ONEs per EmpId. Impliment this using SQL and DataStage both.

6 Answers   IBM,


i have source like balance,drawtime 20000, 8.30 50000,10.20 3000,4.00 i want target like this balance,drawtime 20000, 20.30 50000,22.20 3000,16.00

2 Answers  


Categories