Interested to Buy Any Domain ? << Click Here >> for more details...
WHAT ARE THE COMMON ERRORS IN DATA STAGE?
- 6 Answers
- 36661 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 find no.of records in sequntial file itself?
can a fact table contains textual information
6 Answers HCL, HCL BSERV, IBM,
i having source like emptable,dept table and combined purpose using for the join stage but join stage which partition techq will be prefored? pls given the ans?
How many Key we can define in remove duplicate stage?
What is the difference between odbc and drs stage?
HOW WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD NOT REPEAT EVEN IF THE JOB IS COMPILED REPEATEDELY?
types of errors in datastage?
my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected out put is min(sal) of 10th deptno,max(sal) of 20th deptno,mean(sal) of 30th deptno using aggregation stage
what is advantages of snowflake when it is used?
how do u catch bad rows from OCI stage? And what CLI stands for?
What is a delta record? How you will read it?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
Teradata 
