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
What is difference between symmetric multiprocessing and massive parallel processing?
how can we create a Sorrogate key in transformer stage? I want it in parallel mode
hi All, i have one scenario like if source--->transformer-->2 target sequential files the 1 st target sequential file is loads the data from source and 2nd target sequntial file contain the 1st target total record count,and file name of 1 st target seq file and timestamp seperated by delimeter for example if source have 10 record the 1st target seq file hav 10 records and 2nd target seq file example 10|xyz.txt|20101110 00:00:00 could you please help me out how can i implement in datastage job.
What is Fastly Changing Dimension?
What are the different options associated with dsjob command?
What is mapping?
Explain connectivity between datastage with datasources?
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?
ename like ibm,tcs,hcl need display those records only how?
How to move data set from one server to other?what are the steps to follow to do this?
Define oconv () and iconv () functions in datastage?
what is the diff between sequential file and fileset stages?