WHAT ARE THE COMMON ERRORS IN DATA STAGE?
Answer Posted / 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 |
Post New Answer View All Answers
what is 'reconsideration error' and how can i respond to this error and how to debug this
How a server job can be converted to a parallel job?
What are some different alternative commands associated with "dsjob"?
Which commands are used to import and export the datastage jobs?
What is oci?
whom do you report?
What is the different type of jobs in datastage?
What is the flow of loading data into fact & dimensional tables?
What are the main differences you have observed between 7.x and 8.x version of datastage?
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 many types of sorting methods are available in datastage?
How to Remove Duplicate using SQL?
Could anyone give brief explanation bout datastage admin
Differentiate between hash file and sequential file?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?