Interested to Buy Any Domain ? << Click Here >> for more details...
WHAT ARE THE COMMON ERRORS IN DATA STAGE?
- 6 Answers
- 36620 Views
- IBM, ME, I also Faced
- E-Mail Answers
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
Which warehouse using in your datawarehouse
how to export or import the jobs in .ISX file
What are the types of views in datastage director?
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.
What are stage variables and constants?
What is difference between server jobs & parallel jobs?
What is ibm datastage?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
If you want to use a same piece of code in different jobs, how will you achieve this?
Define Routines and their types?
How many types of sorting methods are available in datastage?
Does datastage support slowly changing dimensions ?
Define orabulk and bcp stages?
Where do you see different stages in the designer?
