Interested to Buy Any Domain ? << Click Here >> for more details...
WHAT ARE THE COMMON ERRORS IN DATA STAGE?
- 6 Answers
- 36436 Views
- IBM, ME, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kiran
hai..,This is Kiran..,
Common error will get while Extraction ,Transforming and
loading the data into target.
1.Data Type Mismatches(eg:non-numeric field in numeric
field).
2.null values in not null fields.
3.fields size different.
4.data type sizes between sorce to target.
| Is This Answer Correct ? | 14 Yes | 2 No |
Answer / badri karthik
Source file not found.
Null value populated NonNullable column
Died with Signal 11(due to server down)
| Is This Answer Correct ? | 11 Yes | 2 No |
Answer / 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 |
Answer / madhu
Broken Pipe,sigint,Dead lock if accessing Database objects,
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / raj
following is genral error that i faced.
1.Column mismatch or invalid no of column.
2.file opening error.
3.parameter are not defined or not given correct value.
4.mutex error
5.process time out.
| Is This Answer Correct ? | 3 Yes | 3 No |
types of errors in datastage?
What are the difference types of stages?
Is the value of staging variable stored temporarily or permanently?
How you Implemented SCD Type 1 & Type 2 in your project?
what is the difference between the active datawarehouse and datawarehouse
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
How to add zero "0" before record in a field?
how to sort two columns in single job in datastage.
Can we use sequential file as source to hash file? Have you do it ?if what error it will give?
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
Define Routines and their types?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
Teradata 
