Interested to Buy Any Domain ? << Click Here >> for more details...
WHAT ARE THE COMMON ERRORS IN DATA STAGE?
- 6 Answers
- 36837 Views
- IBM, ME, I also Faced
- E-Mail Answers
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 to run a sequential file stage in parallel if the stage is used on the TARGET side
Describe the main features of datastage?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What is the purpose of interprocessor stage in server jobs?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
Have you have ever worked in unix environment and why it is useful in datastage?
How to reverse the string using SQL?
Describe the architecture of datastage?
Can you define merge?
What are the different types of lookups in datastage?
What are the important features of datastage?
How to clean the datastage repository?
Define Routines and their types?
