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
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
How do you import and export the datastage jobs?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
Difference between data warehousing and olap?
How do you register plug-ins?
project Steps,hits, Project level HArd things,Solved methods?
What is difference between symmetric multiprocessing and massive parallel processing?
Describe the main features of datastage?
Differentiate between validated and Compiled in the Datastage?
Why do we use exception activity in Datastage?
why do u need the IOS upgradation in a FC switch
How to convert RGB Value to Hexadecimal values in datastage?
Demonstrate experience in maintaining quality process standards?
What is the difference between server job and parallel jobs?
What are the functionalities of link collector?
What are datastage sequences?