WHAT ARE THE COMMON ERRORS IN DATA STAGE?
Answer Posted / kpk
1) NLS - warning
2) Null value populated for a non null column
3) metadata mismatch - check the target databse data type
and lenght.
4) datatype mismatch - wrong datatype used
5) parallel loding not enabled (this is a fatal error in
parallel jobs if the database dosent have parallel loading
enabled - oracle 10g)
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
What are iconv and oconv?
Define Merge?
What are datastage sequences?
How you Implemented SCD Type 1 & Type 2 in your project?
What is the roundrobin collector?
What is a quality stage in datastage tool?
Explain how a source file is populated?
Highlight the main features of datastage?
To see hidden files in LINIX?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
If you want to use a same piece of code in different jobs, how will you achieve this?
What are the types of jobs we have in datastage?
Differentiate between validated and Compiled in the Datastage?
How do you remove duplicate values in datastage?
Explain datastage architecture?