WHAT ARE THE COMMON ERRORS IN DATA STAGE?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different options associated with dsjob command?

947


How we can covert server job to a parallel job?

599


What is the difference between in process and inter process?

674


Can you highlight the main features of ibm infosphere information server?

640


how many rows sorted in sort stage by default in server jobs

3563






What is ibm datastage?

608


Differentiate between data file and descriptor file?

619


options available in sequence job to run,validate?

841


How and where you used hash file?

660


What are orabulk and bcp stages?

652


Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

2431


i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2277


What is the sortmerge collector?

668


What is the different type of jobs in datastage?

577


Explain entity, attribute and relationship in datastage?

636