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
How the ipc stage work?
What is use Array size in datastage
describe the Steps to confiure a Qlogic switch
Explain the situation where you have applied SCD in your project?
If you want to use the same piece of code in different jobs, how will you achieve it?
How can we improve the performance in datastage?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
Can you explain how could anyone drop the index before loading the data in target in datastage?
Notification Activity
What is the difference between operational data stage (ods) and data warehouse?
sed,awk,head
What is data partitioning?
What is process model?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
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