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

detail about sdlc

4 Answers  

Which warehouse using in your datawarehouse

0 Answers   IBM,

in a job of 20 one job is very slow due to that entire job is slow how can u find out which job is slow?

1 Answers   IBM,

table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target?

9 Answers  

how to find diff between 2 dates without using Icon... funtions?

1 Answers  

What is process model?

0 Answers  

I am defining one varaible parameter date in job parameters.I want use this variable date in where clause in source query.

2 Answers   TCS,

what is snow flack schema?

2 Answers  

What is use Array size in datastage

0 Answers  

How to work with XML out put stage? Please explain step by step? i need to generate XML file using Table data. Given is the .XSD file. Please help?

2 Answers   TCS,

when U have a remove dublicate option in sort stage, why we have a remove dublicate stage in PX, thought it is recamended to sort data before using a remove dublicate stage. I hae been thinking this from days....

4 Answers   Target,

hi this is kiran i have one table i want divide the table with two different table like even rows and odd rows how can i do this one tell me plzz

4 Answers