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
- 6124 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
Difference between ‘validated ok’ and ‘compiled’ in data stage?
What is use Array size in datastage
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
What are the functionalities of link collector?
Can we use target hash file as a lookup ?
Does datastage support slowly changing dimensions ?
What is the purpose of pivot stage?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
what is the custome stage in datastage? how can we impliment that one? plz tell me
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 components of datastage?
What are the different types of lookups in datastage?
On which interface you will be working as a developer?
What are transforms and what is the differenece between routines and transforms?
How can one find bugs in job sequence?
