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


Please Help Members By Posting Answers For Below Questions

How the ipc stage work?

678


What is use Array size in datastage

1310


describe the Steps to confiure a Qlogic switch

1941


Explain the situation where you have applied SCD in your project?

1565


If you want to use the same piece of code in different jobs, how will you achieve it?

640






How can we improve the performance in datastage?

654


hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2426


Can you explain how could anyone drop the index before loading the data in target in datastage?

899


Notification Activity

901


What is the difference between operational data stage (ods) and data warehouse?

677


sed,awk,head

971


What is data partitioning?

745


What is process model?

1555


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?

1764


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

1122