Interested to Buy Any Domain ? << Click Here >> for more details...
how can we do null handling in sequential files
- 2 Answers
- 8685 Views
- Reliance, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kiran
go to target level of Seq_file ,click on Format Tab then
click on field format and select null field values=0.
| Is This Answer Correct ? | 19 Yes | 2 No |
Answer / venkat
go to target level of sequence file,click on format tab and then click field format select and put the value=''
| Is This Answer Correct ? | 0 Yes | 2 No |
How can we read latest records in a text file named file1.txt using seq file stage only? file1 having 100 records in that 5 record sare latest records.How can we read that latest records?
How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?
Difference between sequential file and data set?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
I have a input as: Col 1 1 2 2 3 I want 3 output as: Output1: 1 1 Output2: 2 2 Output3: 3 i.e. same duplicates should be in one target, other duplicate values should be in another target and so on.. Pls help
SEQUENTIAL FILE I HAVE ONE RECORD,I WANT 100 RECORDS IN TARGET?HOW CAN WE DO THAT?PLS EXPLAIN ME AND WHAT STAGES ARE THERE?WHAT LOGIC?
Describe the main features of datastage?
What is apt_config in datastage?
which cache supports connected & un connected Lookup
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
Explain the ChangeApply stage?
how to handle null values using transformer stage?
Teradata 
