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
what is operator combinality in datastage?
What is a ds designer?
How to perform incremental load in datastage?
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
what is .dsx files
CHANGE CAPTURE
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?
can any one tell me how to install datastage 8.1 in windows xp with wizard
To see hidden files in LINIX?
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?
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.
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