Interested to Buy Any Domain ? << Click Here >> for more details...
WHAT ARE THE COMMON ERRORS IN DATA STAGE?
- 6 Answers
- 36848 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 CAN WE SEE THE DATA IN DATASET?
12 Answers IBM, TCS,
30 jobs are running in unix.i want to find out my job.how to do this?Give me command?
which cache supports connected & un connected Lookup
souce file having the columns like name company krish IBM pooja TCS nandini WIPRO krish IBM pooja TCS if first row will be repeat i want the result like this name company count krish IBM 1 pooja TCS 1 nandini WIPRO 1 krish IBM 2 pooja TCS 2
I have a few records all are same structures data, I want to store data in multiple targets how?
by using dsjob..we can run only one job at a time?how can u run multiple jobs at a time in unix?
How do you design PX Routines ?
Name the different types of Lookups in Datastage?
How do you run datastage job from the command line?
what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs?
IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?
LIST THE BUILT-IN STAGES AVALIABLE IN SERVER JOBS?
Teradata 
