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

In Datastage, how you can fix the truncated data error?

839


What are the various kinds of the hash file?

877


Can you explain repository tables in datastage?

1134


What is size of a transaction and an array means in a datastage?

1019


How to implement complex jobs in data stage?

846


On which Dimension Table you implemented SCD Type in your Project

1778


What are the functionalities of link collector?

830


Is possible to create skid in dim,fact tables?

2380


Define oconv () and iconv () functions in datastage?

1098


What are the benefits of datastage?

927


how do u catch bad rows from OCI stage? And what CLI stands for?

2524


Explain entity, attribute and relationship in datastage?

838


Demonstrate experience in maintaining quality process standards?

2168


What is the difference between hashfile and sequential file?

924


Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

1974