How can we do null handling in sequential files
Answers were Sorted based on User's Feedback
Answer / phani kumar
Sequential file doesn't handle nulls. If the file contains
nulls, then it gives records while reading the file by using
sequential stage,only records which are not having nulls.
In order to handle nulls, there is a option available in
seq.file as NULL TO VALUE. Here, we can give any value for
replacing of Nulls.
Then, DS Engine will consider those symbols are nulls while
reading the data from sequential file.
Thanks and regards,
Phani kumar
Is This Answer Correct ? | 5 Yes | 2 No |
Answer / kak
In sequential file we have one property null to value or
null to zero using that we can handle the nulls.
Is This Answer Correct ? | 4 Yes | 2 No |
Differentiate between datastage and datastage tx?
I HAVE EMP TABLE, 4 COLS R THERE COL1,COL2,COL3,COL4 ID-- 101,102,103,104 SAL-- 1000,4000,2000,5000 DATE-- COLUMN. I WANT TO DISPLAY THE DATA PREVIOUS MONTH HIGEST SAL ?
Hi I have scenario like this s/r table T/r table ename,sal empno,ename,sal vijay,2000 1 , vijay, 2000 kumar,3000 2 ,kumar , 3000 ravi ,4000 3 ,ravi , 4000 How can i get target table like that without using Transformer stage?
how to create document in datastage?
what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
What is usage analysis in datastage?
What is difference between join, merge and lookup stage?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
job locking methods? How can we unlock the job?
which memory is used by lookup and join