Interested to Buy Any Domain ? << Click Here >> for more details...
How can we do null handling in sequential files?
- 3 Answers
- 17703 Views
- Reliance, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / krishnabadimala@gmail.com
we can do null handling in sequential file by using null
field value option.which is available in format tab then we
have to et null field value=<what do u want>
| Is This Answer Correct ? | 16 Yes | 0 No |
Answer / dheeraj
we can do null handling in sequential file by using null
field value option.which is available in format tab.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?
What is lookup table?
How to reverse the string using unix?
Explain the ChangeApply stage?
Can you explain kafka connector?
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 ?
How many types of views are there in a datastage director?
What is Horizontal transformation, vertical transformation,diagonal transformation?
What are the types of views in datastage director?
How did you reconcile source with target?
This is UNIX question asked in DataStage Interview. Say I have n numbers of records in a text file. I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file. (Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)
what is the difference between 7.1,7.5.2,8.1 versions in datastage?
Teradata 
