WHAT ARE THE COMMON ERRORS IN DATA STAGE?
- 6 Answers
- 35120 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 |
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
I have 5 different sources i want same records in 5 different targets Can you any body send me this question answer rathdsetl@gmail.com
What is RCP?
What is the difference between operational data stage (ods) and data warehouse?
how to transfer file from one system to another system in unix? which cmd to be use?
1)Source file contains one record, I want 100 records in target file.
source has 2 fields like COMPANY LOCATION IBM HYD TCS BAN IBM CHE HCL HYD TCS CHE IBM BAN HCL BAN HCL CHE LIKE THIS....... AND I WILL GET THE OUTPUT LIKE THIS.... Company loc count TCS HYD 3 BAN CHE IBM HYD 3 BAN CHE HCL HYD 3 BAN CHE PLZ SEND ME ANSWER FOR THIS QUESTION..........
how to design the change capture stage in(data stage parallel jobs) type 2
How to delete the data in dataset?types of deleting the data in dataset?
How do u convert the columns to rows in datastage?
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.
Teradata 
