Interested to Buy Any Domain ? << Click Here >> for more details...
WHAT ARE THE COMMON ERRORS IN DATA STAGE?
- 6 Answers
- 36654 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 |
How to convert alpha Numeric values to alpha using functions?
how CAN we remove duplicates in dataset?
what is the difference between the join and look up explin me one exmple
What a datastage macro?
create a job to get the previous row salary for the current row.if there is no previous row exists for the current row,then the previous row salary should be displayed as null? empid salary previoussalary 10 1000 null 20 2000 1000 30 3000 2000 40 4000 3000
hi, 1)totally how many jobs created in ur project 2)what is ur datamart size & Dwh size 3)How secure ur project 4)could u plz tell be about testing process after complete the job will run sucessfully or not in Datastage
What is lookup table?
Give an idea of system variables.
Hi guys, In sequencer job, we have 3 sources, in that 1st source have some records, Here requirement is 1st source records are 100 then only run the job otherwise total job will abort... How to calculate this. please design the job. Thanks.
which r the connectors used in san?
How many Nodes configuration file you used in your last project?
SOURCE LIKE I_D,F1,F2 --------- 100,N,Y 100,N,N 100,Y,N 101,Y,Y 101,N,Y 102,Y,N 103,N,N 104,Y,Y 105,N,N 106,N,Y 102,N,Y 105,Y,Y O/P LIKE ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y
Teradata 
