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
What are the different type of jobs in datastage?
Explain datastage architecture?
Can you explain kafka connector?
Differentiate between odbc and drs stage?
How many types of hash files are there?
What is the flow of loading data into fact & dimensional tables?
EXPLAIN SCD
What is process model?
Where do you see different stages in the designer?
What is the importance of the exception activity in datastage?
Can you explain link buffering?
Define meta stage?
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
Difference between sequential file and data set?
How do you generate sequence number in datastage?