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
- 5054 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
What are the components of ascential data stage?
If you want to use the same piece of code in different jobs, how will you achieve it?
How do you start developing a datastage project?
What are the types of containers in datastage?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
what is the use of materialized view?
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 kinds of views available in a datastage director?
What are the types of views in datastage director?
Why fact table is in normal form?
Differentiate between operational datastage (ods) and data warehouse?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What is the use of datastage designer?
Can you explain kafka connector?
How you Implemented SCD Type 1 & Type 2 in your project?
