how to handle null values in sequential file?
- 1 Answers
- 19075 Views
- HCL, I also Faced
- E-Mail Answers
Answer / satyanarayana
GO to the Format tab in the sequential file then select the
Field defaults option and then select Null field value
option at right side bottom and then provide the
value...........
| Is This Answer Correct ? | 28 Yes | 3 No |
i have a scenario in which i/p columns areID,salary with 1,1000 2,2000 and 3,3000 i need an extra column in the o/p named avg(salary)how can i get it?
What r the existing server jobs in parallalism?
WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE FIELD
how to do pergformence tuning in datastage?
How to display all the duplicate records from the oracle Table?
in one scenario source flat file like Fileld1 00122001550056200568 00256002360014500896 00123004560078900258 00147004560025800256 divide each 5 numbers as one column i.e here i need field1 field2 field3 field4 00122 00155 00562 00568 00256 00236 00145 00896 00123 00456 00789 00258 00147 00456 00258 00256 plz help me....
How we can convert rows to columns in datastage?
How many Nodes configuration file you used in your last project?
How to manage date conversion in Datastage?
Can you filter data in hashed file?
How the ipc stage work?
How to initialize environment variables?
Teradata 
