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
- 6106 Views
- I also Faced
- E-Mail Answers
Answer Posted / shar
When
col is converted from not null to null and data coming has
null or not null values then NO Problem.
But col is NULL constraint and converted to Not NULL then
two cases
i) when data coming from source has no NULL values then no
problem.
ii)when data coming from source has NULL values then the job
simply ABORTS.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Which algorithm you used for your hashfile?
how to delete one row in target dataset
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
describe the Steps to confiure a Qlogic switch
what is the use of surogate key in datastage
How many types of views are there in a datastage director?
sed,awk,head
How to convert RGB Value to Hexadecimal values in datastage?
Define Data Stage?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
Have you used Unstructured data?
Differentiate between data file and descriptor file?
What are the types of containers and how to create them?
Why do we use link partitioner and link collector in datastage?
Explain connectivity between datastage with datasources?
