Interested to Buy Any Domain ? << Click Here >> for more details...
How can we do null handling in sequential files?
- 3 Answers
- 17875 Views
- Reliance, I also Faced
- E-Mail Answers
Answer Posted / naga
While importing the data we can specifie nullable 'yes' in define tab.
or
In format tab we can specifie the Final delimeter as 'null'.
| Is This Answer Correct ? | 5 Yes | 8 No |
Post New Answer View All Answers
Is possible to create skid in dim,fact tables?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
What are the difference types of stages?
Where do you see different stages in the designer?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
Which warehouse using in your datawarehouse
How a source file is populated?
What are the types of jobs we have in datastage?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
What are the components of ascential data stage?
How complex jobs are implemented in datstage to improve performance?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
Explain entity, attribute and relationship in datastage?
what is the use of materialized view?
