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
- 6092 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 is the use of hoursfromtime() function in transformer stage in datastage?
Name the command line functions to import and export the DS jobs?
Define project in datastage?
What is the difference between informatica and datastage?
What are data elements?
What is staging variable?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
Define orabulk and bcp stages?
how to write server Routine coding?
Define Routines and their types?
State the difference between an operational datastage and a data warehouse?
Can you explain link buffering?
What is the sortmerge collector?
How many types of sorting methods are available in datastage?
How to implement complex jobs in data stage?
