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
- 6096 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
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What is difference between server jobs & parallel jobs?
how to delete one row in target dataset
Why fact table is in normal form?
How the ipc stage work?
Define Data Stage?
Differentiate between datastage and informatica?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What is the difference between datastage and informatica?
what is flow of project?
How can we improve the performance in datastage?
Give an idea of system variables.
How many types of hash files are there?
