Answer Posted / mallika
Sequential file stage doesn't recognize nulls. So in format
tab you will find an option null to value property and there
you can enter any value
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
EXPLAIN SCD
How many types of sorting methods are available in datastage?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What are the types of containers?
What is the flow of loading data into fact & dimensional tables?
How a server job can be converted to a parallel job?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
How can you write parallel routines in datastage PX?
What are the types of jobs we have in datastage?
How can we improve the performance in datastage?
Where do the datastage jobs get stored?
Explain the situation where you have applied SCD in your project?
Notification Activity
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
How to convert RGB Value to Hexadecimal values in datastage?
