Interested to Buy Any Domain ? << Click Here >> for more details...
Is there no issue when you try to convert a NOt null column
in nullable and vice versa in aggregator styage and
transformer stage? When I tried i got the warnings but in a
running code I can see such type of scenarios. Please
explain
- 2 Answers
- 5988 Views
- I also Faced
- E-Mail Answers
Answer Posted / subhash
1) there is no issue when you are converting NOT NULL column to NULLABLE column even if get null data from source.
2) But when you are converting nullable column to NOT nullable column also you will not get any issue if you get the NOT NULL data from source,
if you get nullable data from source then job will ABORT.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Describe stream connector?
Explain entity, attribute and relationship in datastage?
What are the different kinds of views available in a datastage director?
Different ways a project can be moved to production ?...example ….export-import and Version control.
Explain ibm infosphere information server and highlight its main features?
What is the difference between in process and inter process?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
What all the types of jobs you developed?
How you Implemented SCD Type 1 & Type 2 in your project?
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.
Differentiate between Join, Merge and Lookup stage?
What is difference between server jobs & parallel jobs?
What is quality stage?
what is use of SDR function?
Which commands are used to import and export the datastage jobs?
