Interested to Buy Any Domain ? << Click Here >> for more details...
How can we do null handling in sequential files?
- 3 Answers
- 17661 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 |
1. How many People are part of your Team? 2. Explain how you create jobs or flow of project? 3. Join Stage vs Lookup vs Merge Stage 4. Summation scenario based question - How you find sum of salary for a specific employee (Explain stages and flow of job)? 5. Explain Remove duplicates stage ? Can you do sort in this stage? 6. SQL Questions - Joins - Types, Difference between Join and Union 7. Unix Questions - How you run the Job, How you list all jobs in project 8. Explain Environmental Variables? 9. SQL Scenario - If you have 3 Identical record in a Table, Ex: 1, Ram, Xyz; 1, Ram, Xyz; 1, Ram, Xyz; Delete only 2 of the records and keep only 1 using the Delete query. How you will you do this?
WHAT ARE THE COMMON ERRORS IN DATA STAGE?
i have 3 diffrent tables. 1) US rate data 2)CANADA rate data and 3)MEXICO rate data. All 3 tables have 6 collumns each. 4 collumns are commun to all tables and 2 are diffrent. Now at target i want single table say Country rate which will have (4+2+2+2+1 flag) 11 collumns. I will add a flag collumn which will indicate country and will put nullable collumns which are not common to other. How i can implement this in datastage?
I have source like "abcdefghijklmnopqrs", how to change 10th character from j to z in datastage?
how can u find out the datastage job is running on how many nodes
how to add a new records into source?
A table containg 100 records B table containg 20 records we have to join two tables in left outer it containg target 100 records but target containg 101 record at that time what is the issue arise
Hai..,This Kiran . how to immlement SCD's through sequential file.please explain briefly.if nt ask me i will explain ,what i know.
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
What are the different types of lookups in datastage?
Explain datastage architecture?
How can we do null handling in sequential files
Teradata 
