How can we do null handling in sequential files?
- 3 Answers
- 17058 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
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
What is the difference between in process and inter process?
What are the different layers in the information server architecture?
What is the method of removing duplicates, without the remove duplicate stage?
what are the devoleper roles in real time? plz tell i am new to datastage....
What is active and passive stage?
What is the difference between Datastage 7.5 and 7.0?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
Difference between in process and inter process?
What is merge stage?
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)
How do you remove duplicate values in datastage?
What is a datastage job?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
I have a few records just I want to store data in to targets cycling way how?
